Practice Questions

multi-table 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

Chapter 19: Multi-Table Clear filters

ID	Title	Level	FTPR	Lecture
36	Actors from film 'AFRICAN EGG'	Easy	32%	3.1
37	Most popular movie category	Easy	15%	3.1
38	Most popular movie category (name and id)	Medium	19%	3.1
39	Most productive actor with inner join	Easy	22%	3.1
40	Top 2 most rented movie in June 2020	Medium	14%	3.1
41	Productive actors vs less-productive actors	Hard	7%	3.2
42	Films that are in stock vs not in stock	Medium	12%	3.2
43	Customers who rented vs. those who did not	Medium	8%	3.2
44	In-demand vs not-in-demand movies	Medium	6%	3.2
45	Movie inventory optimization	Hard	9%	3.2
46	Actors and customers whose last name starts with 'A'	Easy	31%	3.3
47	Actors and customers whose first names end in 'D'.	Easy	40%	3.3
48	Movie and TV actors	Easy	38%	3.1
49	Top 3 money making movie categories	Medium	18%	3.1
50	Top 5 cities for movie rentals	Easy	22%	3.1
51	Movie only actor	Easy	37%	3.2
52	Movies cast by movie only actors	Easy	11%	3.2
53	Movie groups by rental income	Hard	11%	3.2
54	Customer groups by movie rental spend	Medium	20%	3.2
55	Busy days and slow days	Medium	10%	3.2
56	Total number of actors	Easy	30%	3.2
57	Total number of actors (with UNION)	Easy	37%	3.3
87	Top song in the US and UK spotify	Medium	9%	3.3
91	same day friend request acceptance rate spotify	Easy	13%	3.1
94	Top 3 products vs. bottom 3 products amazon	Medium	7%	3.3
99	Page recommendation facebook	Medium	13%	3.1
100	Advertiser ROI facebook	Medium	8%	3.2
104	MAU: Monthly active users google	Easy	20%	3.3
118	Daily bookings in the US airbnb	Hard	5%	3.2
129	Top 3 and bottom 3 courier uber	Medium	9%	3.3
140	Daily sales of restaurant 100011 doordash	Hard	8%	3.2
150	Countries with above average customers google	Easy	15%	3.1
162	Number of orders per brand walmart	Easy	41%	3.1
168	Average number of streams in the US tiktok	Medium	13%	3.2
172	Comments distribution facebook	Hard	13%	3.2
179	Members who ever moved from Microsoft to Google linkedin	Medium	31%	3.1
191	Number of replies by group twitter	Medium	18%	3.2
194	Daily active users report for new market snap	Easy	20%	3.2
213	Interchange revenue by issuer and merchant category visa	Easy	70%	3.1

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.