Practice with the full bank, then narrow into a path.
Your active path is foundations track, but the catalog stays broad by default so you can spot harder reps, switch contexts quickly, and still return to the path that best matches your current goal. Starter includes 160 free problems and marks 94 Pro-only problems before you open a gate.
Start broad, then focus when you want structure.
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed. We keep all paths visible first so hard questions do not disappear.
· 94 Pro problems · Filter:
Company
Difficulty
Path
Browse first, then sign in when you want to run SQL.
Free problems open for practice. Pro unlocks the full bank, study plan, and mock interviews.
IshaSQL Pro — 30-day pass
₹999
30 days of Pro access. Renew or extend anytime; extra time stacks from your current end date.
IshaSQL Pro — annual pass
₹7,999
365 days of Pro access. Renew or extend anytime; extra time stacks from your current end date.
8+ months free vs buying 30-day passes.
Foundations Track
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...
Interview Core Track
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.
Foundations Track
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...
Foundations Track
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...
Foundations Track
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...
Foundations Track
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....
Foundations Track
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...
Foundations Track
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.
Foundations Track
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...
Foundations Track
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 ...
Foundations Track
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...
Foundations Track
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...
Foundations Track
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 ...
Foundations Track
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...
Foundations Track
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...
Foundations Track
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_...
Foundations Track
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...
Interview Core Track
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...
Interview Core Track
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...
Interview Core Track
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...
Analytics Reporting Track
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.
Interview Core Track
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...
Analytics Reporting Track
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...
Interview Core Track
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...
Interview Core Track
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...