all companies

Google SQL interview questions

Clean, efficient solutions — frequency counting, ranking and algorithmic Python. Practice reconstructed Google-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.

sqlpandaspythoneasy1medium6hard3

typical interview loop

  1. 1.Recruiter screen
  2. 2.Technical phone screen (SQL or Python)
  3. 3.Onsite: coding, statistics, role-related knowledge, Googleyness
  • › Talk through complexity for Python answers.
  • › Know window functions cold.

most-tested topics

GROUP BY
3
groupby
2
strings
2
dicts
2
ratios
2
JOIN
2

Based on 10 reconstructed Google-style questions.

practice path

1 free · 9 Pro
type
level
  1. 1Searches per devicesqleasy
  2. 2Ad auction eCPM by campaignpandasmedium
  3. 3Campaign tracking from URLspythonmedium
  4. 4Click-through rate per querypandasmedium
  5. 5Normalize and count queriespythonmedium
  6. 6Revenue per campaignsqlmedium
  7. 7Search click-through by categorysqlmedium
  8. 8Advertiser spend cohortssqlhard
  9. 9Days to a user's second searchsqlhard
  10. 10Rolling 7-day active creatorssqlhard

Unlock all 10 Google questions with Pro.

upgrade