16 SQL practice questions in our Google collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
4 Easy · 7 Medium · 5 Hard
Independent practice resource. Not affiliated with or endorsed by Google.
These topics come from the questions in this set. Pick one to open the matching problems.
Find the top 10 external email senders (not @google.com) who sent the most messages to Google employees (@google.com) in the last 30 days. Return sender_email and message_count, sorted by message_count descending (break count ties alphabetically by sender_email).
For each user and date, rank days by event_count where the highest count gets rank 1. If two days have the same event count, they get the same rank and the next rank is not skipped (use DENSE_RANK). Return user_id, event_date, event_count, and rank.
A search session is defined as a sequence of queries from the same user within 15 minutes of each other. If more than 15 minutes pass between queries, a new session starts. Calculate the average number of queries per session for each user. Return user_id and avg_queries_per_session.
16 Google problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
user_id (BIGINT) · event_date (DATE) · event_count (BIGINT)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Google SQL free188 SQL practice questions. 23 companies. Free access to every problem.