We find recently asked interview questions from the top tech companies ranging from SQL, algorithms, machine learning, product intuition, statistics, and more.
Solve three questions a week given on Monday, Wednesday, and Friday before getting the solutions the next morning.
We email the solutions the next day with detailed explanations to each problem that will help you learn the concepts and get better at solving.
Given a table of users and a table of comments called user_comments, 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
I found the questions really helpful when I was interviewing. They were actually relevant, from companies that I applied to, and so a few of the questions actually showed up and I was well prepared to answer them.
Learn more...
Interview Query is great! The solutions are really well written and the concepts in the sql questions were surprisingly repeated a couple times in all of my interviews.
Learn more...
I used these questions when I was studying while looking for my next job. They're super comprehensive, made the questions easy to understand, and I felt well-prepped going into my interviews.
Learn more...