Google practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Explore 25 Google-tagged SQL scenarios focused on query basics, aggregation, filtering.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
25
Estimated prep time
575 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Google-tagged set.
Query basics
15
Aggregation
13
Filtering
9
Joins
5
Date functions
3
Analytics reporting
1
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Advertiser Health Status
Practice query basics through a Google-tagged business scenario.
Complete Skill Coverage
Practice query basics through a Google-tagged business scenario.
Duplicate Job Posts
Practice query basics through a Google-tagged business scenario.
Question list
The current Google-tagged list with learning objectives and your latest status.
Advertiser Health Status
Classify each advertiser based on month-over-month spend. Return advertiser_id and status using these rules: New if previous_month_spend is 0 and current_mon...
Practice query basics through a Google-tagged business scenario.
Complete Skill Coverage
At Google, analysts are preparing a scorecard focused on complete skill coverage. Return each employee_id that qualifies as a subject matter expert by having...
Practice query basics through a Google-tagged business scenario.
Duplicate Job Posts
Use this Google trend check to work on duplicate job posts. Return the number of employers that posted the same role_name in the same city more than once dur...
Practice query basics through a Google-tagged business scenario.
Departments Above Average Pay
Google is reviewing departments above average pay through a operations review. Return each department_id whose average salary exceeds the company average sal...
Practice query basics through a Google-tagged business scenario.
2024 App Click Volume
At Google, analysts are preparing a growth review focused on 2024 app click volume. Return each app_id and the total number of click events recorded in 2024....
Practice query basics through a Google-tagged business scenario.
Frequent Support Callers
At Google, analysts are preparing a ops memo focused on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3...
Practice query basics through a Google-tagged business scenario.
Creators With Multiple 2024 Posts
Use this Google priority review to work on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a Google-tagged business scenario.
Loss-Making Drug Totals
Google wants a operations review for loss-making drug totals. Return each manufacturer with the number of loss-making drugs and the total absolute loss. Sort...
Practice query basics through a Google-tagged business scenario.
Google Pay Transaction Outcomes
For January 2024, what are the total counts of successful and failed transactions in each merchant category? This analysis will help the Google Pay security ...
Practice aggregation through a Google-tagged business scenario.
10070 Deepmind Employment Competition
SELECT p.team_id, AVG(s.member_score) as team_score FROM google_competition_participants p JOIN google_competition_scores s ON p.member_id = s.member_id GROU...
Practice joins through a Google-tagged business scenario.
Remaining Server Capacity
Each server has a total capacity and may have multiple workloads assigned. Return server_id and remaining_capacity for every server, including servers with n...
Practice query basics through a Google-tagged business scenario.
Employee Query Activity Histogram
At Google, analysts are preparing a scorecard focused on employee query activity histogram. Return the number of employees who issued 0 queries, 1 query, 2 q...
Practice query basics through a Google-tagged business scenario.
May Orders By Region
Google wants a portfolio scan for may orders by region. Return each region and the number of orders placed during May 2024. Sort by region.
Practice query basics through a Google-tagged business scenario.
The Number Of Employees Which Report To Each Employee
Google is reviewing the number of employees which report to each employee through a performance snapshot. Return each department_id whose average salary exce...
Practice query basics through a Google-tagged business scenario.
4. Determine the Most Popular Google Search Category
For this scenario, assume that Google wants to analyze the top searched categories in their platform to optimize their search results. We have two tables, se...
Practice joins through a Google-tagged business scenario.
2078 From Microsoft To Google
WITH employers_cte AS ( SELECT *, LEAD(employer) OVER(PARTITION BY user_id ORDER BY start_date) as next_employer FROM linkedin_users ) SELECT COUNT(DISTINCT ...
Practice filtering through a Google-tagged business scenario.
9822 Average Number Of Friends
SELECT AVG(t2.num_friends) as avg_num_friends_per_user FROM ( SELECT t1.user, COUNT(friend) as num_friends FROM ( SELECT user_id as user, friend_id as friend...
Practice aggregation through a Google-tagged business scenario.
9811 Find The Minimal Adwords Earnings For Each Business Type
WITH ranked_earnings as ( SELECT business_type, adwords_earnings, RANK() OVER(PARTITION BY business_type ORDER BY adwords_earnings) as rn FROM google_adwords...
Practice filtering through a Google-tagged business scenario.
14 Medium Google Invalid Search Results
-- invalid search results -- WITH search_details AS ( SELECT country, SUM(num_search) AS total_search, SUM(num_search * (invalid_result_pct/100)) AS invalid_...
Practice aggregation through a Google-tagged business scenario.
Bull And Bear Word Frequency
Google is reviewing bull and bear word frequency through a scorecard. The market content team wants to count occurrences of the words bull and bear in stored...
Practice aggregation through a Google-tagged business scenario.
Power Usage Outliers
Infrastructure wants to flag racks with unusual power spikes. Return rack_id, usage_date, kilowatt_hours, and the rack_average rounded to two decimals for ro...
Practice query basics through a Google-tagged business scenario.
Second-highest Salary
Google wants a trend check for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.
Practice query basics through a Google-tagged business scenario.
Monthly Reactivated Users
Use this Google readout to work on monthly reactivated users. Count how many users logged in during a month after being inactive in the previous month. Retur...
Practice query basics through a Google-tagged business scenario.
11 Odd And Even Measurements
-- Assume you're given a table with measurement values obtained from a Google sensor over multiple days with measurements taken multiple times within each da...
Practice aggregation through a Google-tagged business scenario.
Handyman Earnings Per Employee Mode
Use this Google scorecard to work on handyman earnings per employee mode. The ads finance team wants the most common adwords earnings per employee value amon...
Practice aggregation through a Google-tagged business scenario.