with a Gmail account to unlock — no forms, no spam.

20 Real SQL Interview Questions and Answers

-- For Data Scientists, Applied Scientists, and Product Data Scientists --

This is a curated, evolving list of real SQL interview questions and answers, designed by a former Meta Staff Data Scientist who is still actively interviewing candidates (albeit currently as a Staff ML Scientist). Practicing these questions will help you prepare for Data Scientist and Product Data Scientist roles at FAANG and similar-tier companies.

Problem Topics Difficulty
Artist maxranks Join Easy
() Choose house or techno Logical OR Easy
() Songs that stay in the chars for a while Subquery, CTE, Join, ALL, Window functions Medium
() Expensive house songs I Subquery, CTE, Join Medium
() Expensive house songs II Subquery, CTE, Join, Window functions Hard
() Songs that ranked 1 to 50 Between Easy
() Histogram of songs Recursive CTE, Join Hard
() Songs that did not enter the charts or entered high Subquery, Join Medium
() Monthly Active Users (MAU) Aggregation Easy
( Subscription required ) Median songs per artist CTE, Window functions Hard
( Subscription required ) Time to First Activity JOIN, Aggregation Medium
( Subscription required ) Songs with letters Regexp Easy
( Subscription required ) Songs per genre Group by Easy
( Subscription required ) Songs in charts with greater durations Subquery, CTE, Join, Window functions Hard
( Subscription required ) Most Liked Content Per User Join, Window Function, CTE Medium
( Subscription required ) Label recent songs Case Easy
( Subscription required ) Follower-Following Ratios CTEs, Aggregation Medium
( Subscription required ) Engagement Score by User CTEs, WINDOW FUNCTION Hard
( Subscription required ) Concat columns Concat Easy
( Subscription required ) Artists with more songs than others Subquery, CTE, Join, Window functions Hard