Sample a data science interview question
Sign up for our free newsletter to receive the answer
This question was asked by Facebook.
Given a users table and a user_comments table, write a SQL query to generate a histogam of number of comments per user in the month of January 2019. Assume bin buckets intervals of one.
`users` table
columns
type
id
int
name
varchar
joined_at
datetime
city_id
int
device
int
`user_comments` table
columns
type
user_id
int
body
text
created_at
datetime
