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.

CompanyTitleDifficultyXPStatus

Twitter

Histogram of Tweets

easy·+20 XP

TwitterHistogram of Tweetseasy+20

Robinhood

Inactive Traders

easy·+20 XP

RobinhoodInactive Traderseasy+20

Meta

Average Shares Per Post

easy·+20 XP

MetaAverage Shares Per Posteasy+20

Airbnb

Highly Rated Listings

easy·+20 XP

AirbnbHighly Rated Listingseasy+20

Snapchat

Sending vs Opening SnapsPro

medium·+35 XP

SnapchatSending vs Opening SnapsPromedium+35

Lyft

Underperforming DriversPro

medium·+35 XP

LyftUnderperforming DriversPromedium+35

Amazon

Category ExplorersPro

medium·+35 XP

AmazonCategory ExplorersPromedium+35

Google

Top Monthly SearchesPro

medium·+35 XP

GoogleTop Monthly SearchesPromedium+35

Meta

Currently Active PagesPro

medium·+35 XP

MetaCurrently Active PagesPromedium+35

Netflix

Platform SplitPro

medium·+35 XP

NetflixPlatform SplitPromedium+35

Spotify

Premium Artist DiversityPro

medium·+35 XP

SpotifyPremium Artist DiversityPromedium+35

Spotify

7-Day Rolling Listen AveragePro

medium·+35 XP

Spotify7-Day Rolling Listen AveragePromedium+35

Coinbase

Longest Trading StreakPro

hard·+50 XP

CoinbaseLongest Trading StreakProhard+50

Netflix

Viewership Drop AlertPro

hard·+50 XP

NetflixViewership Drop AlertProhard+50

Airbnb

Vacant Days in 2021Pro

hard·+50 XP

AirbnbVacant Days in 2021Prohard+50