Interview Prep

The SQL Interview Room

Real company-style SQL problems from data analyst and data science loops. Open one, write your solution in the editor, then check it against a worked answer and the insight most candidates miss.

Start here
Twitter logoHistogram of TweetsTwitter·easy·Aggregation·+20 XPStart practising →

Question library

15 questions
QuestionTopicsDifficultyXPStatus
Twitter logo
Histogram of Tweets
Twitter
easy+20 XPNot started
Twitter logoHistogram of TweetsTwitterAggregationSubquerieseasy+20 XPNot started
Robinhood logo
Inactive Traders
Robinhood
easy+20 XPNot started
Robinhood logoInactive TradersRobinhoodAnti-joinDate filteringeasy+20 XPNot started
Meta logo
Average Shares Per Post
Meta
easy+20 XPNot started
Meta logoAverage Shares Per PostMetaJOINsAggregationeasy+20 XPNot started
Airbnb logo
Highly Rated Listings
Airbnb
easy+20 XPNot started
Airbnb logoHighly Rated ListingsAirbnbJOINsHAVINGeasy+20 XPNot started
Snapchat logo
Sending vs Opening Snaps
Snapchat
medium+35 XPNot started
Snapchat logoSending vs Opening SnapsSnapchatConditional Aggregation+2medium+35 XPNot started
Lyft logo
Underperforming Drivers
Lyft
medium+35 XPNot started
Lyft logoUnderperforming DriversLyftCTEsWindow functions+1medium+35 XPNot started
Amazon logo
Category Explorers
Amazon
medium+35 XPNot started
Amazon logoCategory ExplorersAmazonMulti-table JOINHAVING+1medium+35 XPNot started
Google logo
Top Monthly Searches
Google
medium+35 XPNot started
Google logoTop Monthly SearchesGoogleCTEsDENSE_RANK+1medium+35 XPNot started
Meta logo
Currently Active Pages
Meta
medium+35 XPNot started
Meta logoCurrently Active PagesMetaWindow functions+1medium+35 XPNot started
Netflix logo
Platform Split
Netflix
medium+35 XPNot started
Netflix logoPlatform SplitNetflixUNION+1medium+35 XPNot started
Spotify logo
Premium Artist Diversity
Spotify
medium+35 XPNot started
Spotify logoPremium Artist DiversitySpotifyCOUNT DISTINCTHAVING+1medium+35 XPNot started
Spotify logo
7-Day Rolling Listen Average
Spotify
medium+35 XPNot started
Spotify logo7-Day Rolling Listen AverageSpotifyRolling window+1medium+35 XPNot started
Coinbase logo
Longest Trading Streak
Coinbase
hard+50 XPNot started
Coinbase logoLongest Trading StreakCoinbaseGaps and islandsCTEs+1hard+50 XPNot started
Netflix logo
Viewership Drop Alert
Netflix
hard+50 XPNot started
Netflix logoViewership Drop AlertNetflixRolling windowCTEs+1hard+50 XPNot started
Airbnb logo
Vacant Days in 2021
Airbnb
hard+50 XPNot started
Airbnb logoVacant Days in 2021AirbnbDate arithmeticLEFT JOIN+1hard+50 XPNot started
Interview record

Your practice record

0of 15

Choose a focus

Practise one skill at a time.

A stronger answer

  1. 1Write your querySolve the problem in a real editor.
  2. 2Compare the approachCheck it against a worked answer.
  3. 3Learn the key insightSee what most candidates miss.
QueryCase

Learn data skills by solving mysteries. Detective games with real courses behind them.

Product

  • Home
  • About
  • Pricing

Departments

  • SQL
  • Excel

Resources

  • SQL Cheat Sheet
  • SQL Interview Questions
  • Excel Cheat Sheet
  • Data Roles Explained
  • Blog

Company

  • Contact Us
  • Privacy Policy
  • Terms of Service

© 2026 QueryCase. All rights reserved.