What SQL questions are asked in Google interviews?

Technical interviews at Google cover 20 curated SQL and relational database queries, including joins, window functions, aggregations, and subqueries.

Are SQL questions common for software engineers and data analysts at Google?

Yes, data engineers, backend engineers, business intelligence analysts, and data scientists at Google are routinely tested on real-world database query problems.

Google SQL

Verified

90 SQL queries·52 Easy·31 Medium·7 Hard

Curated SQL and relational database interview problems asked by Google, ranked by frequency with direct problem links.

DSA (2271)

⌘K

#1757Recyclable and Low Fat Products

Easy·Freq 66%·Acc 88.6%

#175Combine Two Tables

Easy·Freq 55%·Acc 79.7%

#2995Viewers Turned Streamers

Hard·Freq 55%·Acc 42.9%

#176Second Highest Salary

Medium·Freq 50%·Acc 47.5%

#1148Article Views I

Easy·Freq 50%·Acc 76.7%

#181Employees Earning More Than Their Managers

Easy·Freq 45%·Acc 73.5%

#584Find Customer Referee

Easy·Freq 44%·Acc 73.1%

#595Big Countries

Easy·Freq 42%·Acc 68.6%

#197Rising Temperature

Easy·Freq 42%·Acc 51.6%

#1661Average Time of Process per Machine

Easy·Freq 38%·Acc 66.8%

#577Employee Bonus

Easy·Freq 38%·Acc 77.7%

#1251Average Selling Price

Easy·Freq 38%·Acc 37.5%

#570Managers with at Least 5 Direct Reports

Medium·Freq 38%·Acc 49.2%

#1581Customer Who Visited but Did Not Make Any Transactions

Easy·Freq 38%·Acc 67.9%

#1378Replace Employee ID With The Unique Identifier

Easy·Freq 38%·Acc 83.6%

#1280Students and Examinations

Easy·Freq 38%·Acc 61.5%

#180Consecutive Numbers

Medium·Freq 38%·Acc 48.8%

#1193Monthly Transactions I

Medium·Freq 32%·Acc 59.4%

#610Triangle Judgement

Easy·Freq 30%·Acc 74.9%

#183Customers Who Never Order

Easy·Freq 30%·Acc 72.0%

#178Rank Scores

Medium·Freq 28%·Acc 68.2%

#177Nth Highest Salary

Medium·Freq 28%·Acc 39.5%

#1164Product Price at a Given Date

Medium·Freq 27%·Acc 58.1%

#182Duplicate Emails

Easy·Freq 26%·Acc 74.0%

#196Delete Duplicate Emails

Easy·Freq 26%·Acc 66.3%

#1141User Activity for the Past 30 Days I

Easy·Freq 26%·Acc 51.1%

#1211Queries Quality and Percentage

Easy·Freq 26%·Acc 53.8%

#1075Project Employees I

Easy·Freq 26%·Acc 67.0%

#1683Invalid Tweets

Easy·Freq 26%·Acc 85.2%

#550Game Play Analysis IV

Medium·Freq 25%·Acc 41.7%

#1174Immediate Food Delivery II

Medium·Freq 25%·Acc 56.4%

#626Exchange Seats

Medium·Freq 25%·Acc 74.4%

#1633Percentage of Users Attended a Contest

Easy·Freq 25%·Acc 60.6%

#1934Confirmation Rate

Medium·Freq 25%·Acc 62.2%

#620Not Boring Movies

Easy·Freq 25%·Acc 75.1%

#1978Employees Whose Manager Left the Company

Easy·Freq 25%·Acc 48.8%

#184Department Highest Salary

Medium·Freq 25%·Acc 58.6%

#1068Product Sales Analysis I

Easy·Freq 25%·Acc 85.9%

#1731The Number of Employees Which Report to Each Employee

Easy·Freq 25%·Acc 53.5%

#3054Binary Tree Nodes

Medium·Freq 25%·Acc 78.3%

#2985Calculate Compressed Mean

Easy·Freq 25%·Acc 86.3%

#2991Top Three Wineries

Hard·Freq 25%·Acc 54.1%

#2987Find Expensive Cities

Easy·Freq 25%·Acc 77.2%

#2989Class Performance

Medium·Freq 25%·Acc 88.6%

#2990Loan Types

Easy·Freq 25%·Acc 64.3%

#585Investments in 2016

Medium·Freq 25%·Acc 51.4%

#1667Fix Names in a Table

Easy·Freq 25%·Acc 60.6%

#569Median Employee Salary

Hard·Freq 25%·Acc 65.8%

#1270All People Report to the Given Manager

Medium·Freq 25%·Acc 83.9%

#1767Find the Subtasks That Did Not Execute

Hard·Freq 25%·Acc 78.4%

#1821Find Customers With Positive Revenue this Year

Easy·Freq 25%·Acc 87.7%

#1204Last Person to Fit in the Bus

Medium·Freq 18%·Acc 69.5%

#2356Number of Unique Subjects Taught by Each Teacher

Easy·Freq 16%·Acc 89.2%

#1070Product Sales Analysis III

Medium·Freq 16%·Acc 46.2%

#1729Find Followers Count

Easy·Freq 16%·Acc 69.6%

#1341Movie Rating

Medium·Freq 16%·Acc 43.8%

#511Game Play Analysis I

Easy·Freq 16%·Acc 76.5%

#185Department Top Three Salaries

Hard·Freq 15%·Acc 61.0%

#1789Primary Department for Each Employee

Easy·Freq 15%·Acc 74.8%

#262Trips and Users

Hard·Freq 15%·Acc 38.6%

#1517Find Users With Valid E-Mails

Easy·Freq 13%·Acc 35.6%

#1045Customers Who Bought All Products

Medium·Freq 13%·Acc 64.2%

#586Customer Placing the Largest Number of Orders

Easy·Freq 13%·Acc 64.5%

#1484Group Sold Products By The Date

Easy·Freq 13%·Acc 78.1%

#596Classes With at Least 5 Students

Easy·Freq 13%·Acc 64.3%

#1873Calculate Special Bonus

Easy·Freq 13%·Acc 57.1%

#1179Reformat Department Table

Easy·Freq 13%·Acc 76.3%

#1527Patients With a Condition

Easy·Freq 13%·Acc 39.0%

#1321Restaurant Growth

Medium·Freq 13%·Acc 59.2%

#1795Rearrange Products Table

Easy·Freq 13%·Acc 85.5%

#1890The Latest Login in 2020

Easy·Freq 13%·Acc 77.0%

#602Friend Requests II: Who Has the Most Friends

Medium·Freq 13%·Acc 63.0%

#1050Actors and Directors Who Cooperated At Least Three Times

Easy·Freq 13%·Acc 71.2%

#601Human Traffic of Stadium

Hard·Freq 13%·Acc 51.6%

#1158Market Analysis I

Medium·Freq 13%·Acc 57.5%

#1587Bank Account Summary II

Easy·Freq 13%·Acc 82.9%

#619Biggest Single Number

Easy·Freq 13%·Acc 71.6%

#1407Top Travellers

Easy·Freq 13%·Acc 57.5%

#1112Highest Grade For Each Student

Medium·Freq 13%·Acc 71.2%

#3421Find Students Who Improved

Medium·Freq 13%·Acc 49.2%

#1084Sales Analysis III

Easy·Freq 13%·Acc 47.9%

#1907Count Salary Categories

Medium·Freq 13%·Acc 64.8%

#608Tree Node

Medium·Freq 13%·Acc 76.0%

#1949Strong Friendship

Medium·Freq 13%·Acc 54.7%

#3475DNA Pattern Recognition

Medium·Freq 13%·Acc 85.0%

#3586Find COVID Recovery Patients

Medium·Freq 13%·Acc 43.1%

#1693Daily Leads and Partners

Easy·Freq 13%·Acc 86.7%

#607Sales Person

Easy·Freq 13%·Acc 66.1%

#3220Odd and Even Transactions

Medium·Freq 13%·Acc 68.4%

#1965Employees With Missing Information

Easy·Freq 5%·Acc 0.7%

#	SQL Problem	Difficulty	Frequency↓	Acceptance
#1757	Recyclable and Low Fat Products3 sources	Easy	66%	88.6%
#175	Combine Two Tables3 sources	Easy	55%	79.7%
#2995	Viewers Turned Streamers3 sources	Hard	55%	42.9%
#176	Second Highest Salary3 sources	Medium	50%	47.5%
#1148	Article Views I3 sources	Easy	50%	76.7%
#181	Employees Earning More Than Their Managers3 sources	Easy	45%	73.5%
#584	Find Customer Referee3 sources	Easy	44%	73.1%
#595	Big Countries3 sources	Easy	42%	68.6%
#197	Rising Temperature3 sources	Easy	42%	51.6%
#1661	Average Time of Process per Machine3 sources	Easy	38%	66.8%
#577	Employee Bonus3 sources	Easy	38%	77.7%
#1251	Average Selling Price3 sources	Easy	38%	37.5%
#570	Managers with at Least 5 Direct Reports3 sources	Medium	38%	49.2%
#1581	Customer Who Visited but Did Not Make Any Transactions3 sources	Easy	38%	67.9%
#1378	Replace Employee ID With The Unique Identifier3 sources	Easy	38%	83.6%
#1280	Students and Examinations3 sources	Easy	38%	61.5%
#180	Consecutive Numbers3 sources	Medium	38%	48.8%
#1193	Monthly Transactions I3 sources	Medium	32%	59.4%
#610	Triangle Judgement3 sources	Easy	30%	74.9%
#183	Customers Who Never Order3 sources	Easy	30%	72.0%
#178	Rank Scores3 sources	Medium	28%	68.2%
#177	Nth Highest Salary3 sources	Medium	28%	39.5%
#1164	Product Price at a Given Date3 sources	Medium	27%	58.1%
#182	Duplicate Emails3 sources	Easy	26%	74.0%
#196	Delete Duplicate Emails3 sources	Easy	26%	66.3%
#1141	User Activity for the Past 30 Days I3 sources	Easy	26%	51.1%
#1211	Queries Quality and Percentage3 sources	Easy	26%	53.8%
#1075	Project Employees I3 sources	Easy	26%	67.0%
#1683	Invalid Tweets3 sources	Easy	26%	85.2%
#550	Game Play Analysis IV3 sources	Medium	25%	41.7%
#1174	Immediate Food Delivery II3 sources	Medium	25%	56.4%
#626	Exchange Seats3 sources	Medium	25%	74.4%
#1633	Percentage of Users Attended a Contest3 sources	Easy	25%	60.6%
#1934	Confirmation Rate3 sources	Medium	25%	62.2%
#620	Not Boring Movies3 sources	Easy	25%	75.1%
#1978	Employees Whose Manager Left the Company3 sources	Easy	25%	48.8%
#184	Department Highest Salary3 sources	Medium	25%	58.6%
#1068	Product Sales Analysis I3 sources	Easy	25%	85.9%
#1731	The Number of Employees Which Report to Each Employee3 sources	Easy	25%	53.5%
#3054	Binary Tree Nodes3 sources	Medium	25%	78.3%
#2985	Calculate Compressed Mean3 sources	Easy	25%	86.3%
#2991	Top Three Wineries3 sources	Hard	25%	54.1%
#2987	Find Expensive Cities3 sources	Easy	25%	77.2%
#2989	Class Performance3 sources	Medium	25%	88.6%
#2990	Loan Types3 sources	Easy	25%	64.3%
#585	Investments in 20163 sources	Medium	25%	51.4%
#1667	Fix Names in a Table3 sources	Easy	25%	60.6%
#569	Median Employee Salary3 sources	Hard	25%	65.8%
#1270	All People Report to the Given Manager3 sources	Medium	25%	83.9%
#1767	Find the Subtasks That Did Not Execute3 sources	Hard	25%	78.4%
#1821	Find Customers With Positive Revenue this Year3 sources	Easy	25%	87.7%
#1204	Last Person to Fit in the Bus3 sources	Medium	18%	69.5%
#2356	Number of Unique Subjects Taught by Each Teacher3 sources	Easy	16%	89.2%
#1070	Product Sales Analysis III3 sources	Medium	16%	46.2%
#1729	Find Followers Count3 sources	Easy	16%	69.6%
#1341	Movie Rating3 sources	Medium	16%	43.8%
#511	Game Play Analysis I3 sources	Easy	16%	76.5%
#185	Department Top Three Salaries3 sources	Hard	15%	61.0%
#1789	Primary Department for Each Employee3 sources	Easy	15%	74.8%
#262	Trips and Users3 sources	Hard	15%	38.6%
#1517	Find Users With Valid E-Mails3 sources	Easy	13%	35.6%
#1045	Customers Who Bought All Products3 sources	Medium	13%	64.2%
#586	Customer Placing the Largest Number of Orders3 sources	Easy	13%	64.5%
#1484	Group Sold Products By The Date3 sources	Easy	13%	78.1%
#596	Classes With at Least 5 Students3 sources	Easy	13%	64.3%
#1873	Calculate Special Bonus3 sources	Easy	13%	57.1%
#1179	Reformat Department Table3 sources	Easy	13%	76.3%
#1527	Patients With a Condition3 sources	Easy	13%	39.0%
#1321	Restaurant Growth3 sources	Medium	13%	59.2%
#1795	Rearrange Products Table3 sources	Easy	13%	85.5%
#1890	The Latest Login in 20203 sources	Easy	13%	77.0%
#602	Friend Requests II: Who Has the Most Friends3 sources	Medium	13%	63.0%
#1050	Actors and Directors Who Cooperated At Least Three Times3 sources	Easy	13%	71.2%
#601	Human Traffic of Stadium3 sources	Hard	13%	51.6%
#1158	Market Analysis I3 sources	Medium	13%	57.5%
#1587	Bank Account Summary II3 sources	Easy	13%	82.9%
#619	Biggest Single Number3 sources	Easy	13%	71.6%
#1407	Top Travellers3 sources	Easy	13%	57.5%
#1112	Highest Grade For Each Student3 sources	Medium	13%	71.2%
#3421	Find Students Who Improved3 sources	Medium	13%	49.2%
#1084	Sales Analysis III3 sources	Easy	13%	47.9%
#1907	Count Salary Categories3 sources	Medium	13%	64.8%
#608	Tree Node3 sources	Medium	13%	76.0%
#1949	Strong Friendship3 sources	Medium	13%	54.7%
#3475	DNA Pattern Recognition3 sources	Medium	13%	85.0%
#3586	Find COVID Recovery Patients3 sources	Medium	13%	43.1%
#1693	Daily Leads and Partners3 sources	Easy	13%	86.7%
#607	Sales Person3 sources	Easy	13%	66.1%
#3220	Odd and Even Transactions3 sources	Medium	13%	68.4%
#1965	Employees With Missing Information2 sources	Easy	5%	0.7%

Showing 90 of 90 SQL questions in All TimeCompany Total: 90 SQL questions