Reddit Interview Questions

Reddit Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(118)
SQL
(74)
Machine Learning
(64)
Product Sense & Metrics
(47)
Probability
(42)

Reddit Interview Questions

Practice for the Reddit interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

You’re given three tables.

An ads table holds an ID and the advertisement name like “Labor day shirts sale”. The feed_comments table holds the comments on ads by different users that occur in the regular feed. The moments_comments table holds the comments on ads by different users in the moments section.

Write a query to get the percentage of comments, by ad, that occurs in the feed versus mentions sections of the app.

Example:

Input:

feed_comments table

Columns Type
ad_id integer
user_id integer
comment_id integer

moments_comments table

Columns Type
ad_id INTEGER
user_id INTEGER
comment_id INTEGER

ads table

column type
id INTEGER
name VARCHAR

Output:

name percentage_feed percentage_moments
Labor Day .6 .4
Polo Shirts .85 .15
SQL
Medium
Data Structures & Algorithms
Easy
Loading pricing options

View all Reddit, Inc. questions

Challenge

Check your skills...
How prepared are you for working at Reddit, Inc.?

Reddit Salaries by Position

$153K
$218K
Data Scientist
Median: $210K
Mean (Average): $190K
Data points: 13
$128K
$244K
Software Engineer
Median: $180K
Mean (Average): $183K
Data points: 54
Data Engineer*
$175K
Data Engineer
Median: $175K
Mean (Average): $175K
Data points: 1
ML Engineer*
$160K
ML Engineer
Median: $160K
Mean (Average): $160K
Data points: 1
Product Manager*
$150K
Product Manager
Median: $150K
Mean (Average): $150K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Data Scientist role pays the most with a $189,692 base salary while the Product Manager role on average pays the least with a $150,000 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.