Reddit Interview Questions

Reddit Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(91)
SQL
(62)
Machine Learning
(52)
Product Sense & Metrics
(42)
Probability
(38)

Reddit Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

We’re given three tables representing a forum of users and their comments on posts.

Write a query to get the top three users that got the most upvotes on their comments written in 2020. 

Note: Do not count deleted comments and upvotes by users on their own comments

Example:

Input:

users table

Column Type
id INTEGER
created_at DATETIME
username VARCHAR

comments table

Columns Type
id INTEGER
created_at datetime
post_id INTEGER
user_id INTEGER
is_deleted BOOLEAN

comment_votes table

Column Type
id INTEGER
created_at DATETIME
user_id INTEGER
comment_id INTEGER
is_upvote BOOLEAN

Output:

Column Type
id INTEGER
username VARCHAR
upvotes INTEGER
Data Structures & Algorithms
Easy
SQL
Medium
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.