SQL Practice Drills & Schema Reference
15 GCS-like analytics drills from Easy to Hard. Practice writing queries by hand before revealing solutions.
Synthetic GCS Analytics Database Schema
SQLite In-Memory
advertisers
advertiser_id, name, vertical, region, signup_date, segment
advertiser_id, name, vertical, region, signup_date, segment
campaigns
campaign_id, advertiser_id, campaign_type, start_date, status
campaign_id, advertiser_id, campaign_type, start_date, status
daily_spend
campaign_id, date, impressions, clicks, conversions, spend_usd
campaign_id, date, impressions, clicks, conversions, spend_usd
sellers
seller_id, name, team, region
seller_id, name, team, region
assignments
advertiser_id, seller_id, start_date, end_date
advertiser_id, seller_id, start_date, end_date
Note: Interview SQL is often written in a shared Google Doc without running it. Always practice typing your query into the practice editor by hand first, then reveal the model solution.