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.
columns type id int name varchar joined_at datetime city_id int device int
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...