Practice Questions

Hard SQL Interview Questions

Master SQL interview patterns with structured question sets, company filters, and run-ready challenges.

affirm afterpay airbnb amazon apple doordash dropbox ebay facebook google linkedin lyft microsoft netflix robinhood roblox snap spotify tiktok twitter uber visa walmart

Questions Showing

Companies

Access Tier

Free

Level: Hard Clear filters

ID	Title	Level	FTPR	Lecture
14	Good days and bad days	Hard	4%	2.3
15	Fast movie watchers vs slow watchers	Hard	6%	2.3
32	Unpopular movies	Hard	17%	2.3
41	Productive actors vs less-productive actors	Hard	7%	3.2
45	Movie inventory optimization	Hard	9%	3.2
53	Movie groups by rental income	Hard	11%	3.2
58	Percentage of revenue per movie	Hard	8%	4.1
60	Movie rentals and average rentals in the same category	Hard	9%	4.1
61	Customer spend vs average spend in the same store	Hard	11%	4.1
63	Top 5 customers by store	Hard	8%	4.2
64	Top 2 films by category	Hard	14%	4.2
68	Spend difference between first and second rentals	Hard	12%	4.4
69	Number of happy customers	Hard	7%	4.4
73	Number of days to become a happy customer	Hard	11%	4.2
74	The most productive actors by category	Hard	7%	4.2
79	Spend difference between the last and the second last rentals	Hard	16%	4.4
80	DoD revenue growth for each store	Hard	19%	4.4
85	Top 4 queries based on click through rate on new year's day facebook	Hard	7%	2.2
95	Candidate products for subscription amazon	Hard	13%	2.2
102	Histogram by visit session duration google	Hard	17%	2.3
105	Number of days gap between last two actions google	Hard	8%	4.2
108	Free premium membership amazon	Hard	16%	4.1
115	Rolling average revenue amazon	Hard	28%	4.1
118	Daily bookings in the US airbnb	Hard	5%	3.2
119	Top 2 countries by bookings airbnb	Hard	10%	4.2
120	First ever booking airbnb	Hard	10%	4.2
121	Week over week change of first ever bookings airbnb	Hard	14%	4.4
122	Top country by wow growth airbnb	Hard	13%	4.2
126	Top 3 restaurants uber	Hard	10%	2.1
127	Average rating after 10th trip uber	Hard	11%	4.2
131	Churned accounts affirm	Hard	10%	2.3
140	Daily sales of restaurant 100011 doordash	Hard	8%	3.2
141	Cumulative sales of restaurant 100011 doordash	Hard	15%	4.1
145	Returning customers after first buy afterpay	Hard	16%	4.2
147	2 days streak customers google	Hard	13%	4.4
156	Cancellation rate by unbanned users lyft	Hard	15%	2.3
160	Sellers with no sales by day ebay	Hard	11%	2.3
165	Session stitching walmart	Hard	17%	4.2
172	Comments distribution facebook	Hard	13%	3.2
180	Members moved from Microsoft to Google directly. linkedin	Hard	21%	4.4
188	Top 1 popular question by department google	Hard	14%	4.2
190	Twitter campaign spend report twitter	Hard	22%	2.2
195	MoM user growth snap	Hard	14%	4.4
196	User segments report snap	Hard	18%	2.2
199	Students improvement snap	Hard	67%	4.4
201	Top 3 students for each subject snap	Hard	67%	4.2
202	Monthly active paid subscriptions apple	Hard	50%	2.2
203	Top product by country by month apple	Hard	100%	4.2
208	Top 3 urls by testing groups apple	Hard	10%	4.2
212	Highest spender's issuers visa	Hard	0%	4.2
216	Most active customers roblox	Hard	10%	2.2
217	Most engaged customers roblox	Hard	10%	2.1
220	Most Expensive Product in Each Category microsoft	Hard	-	2.1
221	Customers With More Than 5 Products in a Single Transaction microsoft	Hard	-	2.1
222	Product Sales Ranking Within Categories microsoft	Hard	-	2.1
223	Cumulative Total Sales by Day microsoft	Hard	-	2.1
225	Customer Behavior Analysis microsoft	Hard	-	2.1
226	Customer Lifetime Value (CLV) and Segmentation microsoft	Hard	-	2.1
227	Aggregate Sale Amounts per Customer microsoft	Hard	-	2.1
228	Analyzing Sequential Purchase Behavior microsoft	Hard	-	2.1
229	Time Between Repeat Purchases microsoft	Hard	-	4.4

Disclaimer: SQLPad collects interview questions and sample data from public sources. We are not affiliated with the companies mentioned in these exercises. Please review our terms and conditions.