Practice Questions

ROW_NUMBER, RANK, DENSE_RANK 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

Window Functions: ROW_NUMBER, RANK, DENSE_RANK Clear filters

ID	Title	Level	FTPR	Lecture
62	Shortest film by category	Medium	8%	4.2
63	Top 5 customers by store	Hard	8%	4.2
64	Top 2 films by category	Hard	14%	4.2
72	Days when they became happy customers	Medium	10%	4.2
73	Number of days to become a happy customer	Hard	11%	4.2
74	The most productive actors by category	Hard	7%	4.2
75	Top customer by movie category	Medium	26%	4.2
76	Districts with the most and least customers	Easy	12%	4.2
83	Top search_query in US and UK on new year's day facebook	Medium	6%	4.2
88	Top song report spotify	Medium	22%	4.2
90	Top artist report spotify	Medium	21%	4.2
105	Number of days gap between last two actions google	Hard	8%	4.2
109	Top 3 most popular product categories amazon	Easy	11%	4.2
110	Most popular product by category amazon	Medium	12%	4.2
116	Top answers day by device amazon	Easy	14%	4.2
119	Top 2 countries by bookings airbnb	Hard	10%	4.2
120	First ever booking airbnb	Hard	10%	4.2
122	Top country by wow growth airbnb	Hard	13%	4.2
123	Top listing in the United States, United Kingdom and Canada airbnb	Medium	10%	4.2
127	Average rating after 10th trip uber	Hard	11%	4.2
135	Unlucky employees robinhood	Easy	16%	4.2
137	Extremely late first orders doordash	Medium	9%	4.2
139	Poor first delivery experience doordash	Medium	17%	4.2
142	First order date afterpay	Easy	40%	4.2
144	Third order afterpay	Medium	9%	4.2
145	Returning customers after first buy afterpay	Hard	16%	4.2
148	Most popular video category google	Medium	13%	4.2
157	Number of trips before a driver got banned lyft	Medium	10%	4.2
158	First trip completion rate lyft	Medium	22%	4.2
165	Session stitching walmart	Hard	17%	4.2
166	Top 10 customers based on spend growth walmart	Medium	11%	4.2
188	Top 1 popular question by department google	Hard	14%	4.2
201	Top 3 students for each subject snap	Hard	67%	4.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
211	Top issuer by category visa	Medium	30%	4.2
212	Highest spender's issuers visa	Hard	0%	4.2

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.