SQL Interview Questions

Master the world of data! Dive into SQL & Python interview questions and get ready for your SQL interview!

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

ID	Title	Level	FTPR	Lecture
1	Top store for movie sales	easy	24%	2.1
2	Top 3 movie categories by sales	easy	42%	2.1
3	Top 5 shortest movies	easy	49%	2.1
4	Staff without a profile image	easy	66%	2.1
5	Monthly revenue	easy	20%	2.2
6	Daily revenue in June, 2020	medium	12%	2.2
7	Unique customers count by month	easy	18%	2.2
8	Average customer spend by month	easy	20%	2.2
9	Number of high spend customers by month	medium	4%	2.2
10	Min and max spend	easy	11%	2.2
11	Actors' last name	easy	21%	2.3
12	Actors' last name ending in 'EN' or 'RY'	easy	27%	2.3
13	Actors' first name	medium	14%	2.3
14	Good days and bad days	hard	4%	2.3
15	Fast movie watchers vs slow watchers	hard	6%	2.3
16	Staff who live in Woodridge	easy	65%	2.1
17	GROUCHO WILLIAMS’ actor_id	easy	57%	2.1
18	Top film category	easy	22%	2.2
19	Most productive actor	medium	13%	2.2
20	Customer who spent the most	medium	14%	2.2
21	Customer who rented the most	medium	16%	2.2
22	Average cost per rental transaction	easy	42%	2.3
23	Average spend per customer in Feb 2020	easy	16%	2.2
24	Films with more than 10 actors	medium	19%	2.3
25	Shortest film	easy	46%	2.3
26	Second shortest film	easy	30%	2.3
27	Film with the largest cast	easy	27%	2.3
28	Film with the second largest cast	medium	26%	2.3
29	Second highest spend customer	medium	14%	2.3
30	Inactive customers in May	easy	22%	2.3
31	Movies that have not been returned	easy	26%	2.3
32	Unpopular movies	hard	17%	2.3
33	Returning customers	medium	8%	2.3
34	Stocked up movies	easy	27%	2.3
35	Film length report	easy	27%	2.3
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
58	Percentage of revenue per movie	hard	8%	4.1
59	Percentage of revenue per movie by category	medium	6%	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
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
65	Movie revenue percentiles	easy	16%	4.3
66	Movie percentiles by revenue by category	medium	18%	4.3
67	Quartile by number of rentals	easy	24%	4.3
68	Spend difference between first and second rentals	hard	12%	4.4
69	Number of happy customers	hard	7%	4.4
70	Cumulative spend	easy	13%	4.1
71	Cumulative rentals	easy	21%	4.1
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
77	Movie revenue percentiles by category	easy	18%	4.3
78	Quartiles buckets by number of rentals	medium	25%	4.3
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
81	How many people searched on new year's day facebook	easy	24%	2.2
82	The top search query on new year's day facebook	easy	13%	2.2
83	Top search_query in US and UK on new year's day facebook	medium	6%	4.2
84	Click through rate on new year's day facebook	medium	9%	2.2
85	Top 4 queries based on click through rate on new year's day facebook	hard	7%	2.2
86	Top song in the US spotify	easy	18%	2.2
87	Top song in the US and UK spotify	medium	9%	3.3
88	Top song report spotify	medium	22%	4.2
89	Top 5 artists in the US spotify	medium	13%	2.2
90	Top artist report spotify	medium	21%	4.2
91	same day friend request acceptance rate spotify	easy	13%	3.1
92	Acceptance rate first week of 2021 spotify	easy	14%	2.1
93	number of sales for each product this month amazon	easy	20%	2.2
94	Top 3 products vs. bottom 3 products amazon	medium	7%	3.3
95	Candidate products for subscription amazon	hard	13%	2.2
96	Overall acceptance rate facebook	easy	13%	2.2
97	Social influencer facebook	easy	10%	2.2
98	Most popular user facebook	easy	33%	2.2
99	Page recommendation facebook	medium	13%	3.1
100	Advertiser ROI facebook	medium	8%	3.2
101	Average number of visits per user google	easy	14%	2.2
102	Histogram by visit session duration google	hard	17%	2.3
103	Median and average session duration by day of the week google	medium	20%	4.3
104	MAU: Monthly active users google	easy	20%	3.3
105	Number of days gap between last two actions google	hard	8%	4.2
106	Mobile vs. web google	medium	10%	2.2
107	Customer count by platform google	medium	17%	2.2
108	Free premium membership amazon	hard	16%	4.1
109	Top 3 most popular product categories amazon	easy	11%	4.2
110	Most popular product by category amazon	medium	12%	4.2
111	Second most popular product amazon	medium	16%	2.1
112	Top 3 customers amazon	easy	30%	2.2
113	Daily cumulative spend amazon	easy	11%	4.1
114	Dod revenue change rate amazon	easy	15%	4.4
115	Rolling average revenue amazon	hard	28%	4.1
116	Top answers day by device amazon	easy	14%	4.2
117	Rolling 7 days total answers amazon	easy	35%	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
123	Top listing in the United States, United Kingdom and Canada airbnb	medium	10%	4.2
124	Active restaurants by city uber	easy	41%	2.2
125	Active restaurants with fewer than 5 trips per city uber	easy	16%	2.2
126	Top 3 restaurants uber	hard	10%	2.1
127	Average rating after 10th trip uber	hard	11%	4.2
128	Completion rate uber	easy	26%	2.2
129	Top 3 and bottom 3 courier uber	medium	9%	3.3
130	Newly created accounts affirm	easy	37%	2.2
131	Churned accounts affirm	hard	10%	2.3
132	Top 3 trending countries affirm	medium	9%	2.2
133	Small departments robinhood	easy	45%	2.2
134	Expensive departments robinhood	medium	38%	2.2
135	Unlucky employees robinhood	easy	16%	4.2
136	Extremely late orders doordash	easy	11%	2.3
137	Extremely late first orders doordash	medium	9%	4.2
138	Happy restaurants doordash	easy	14%	2.3
139	Poor first delivery experience doordash	medium	17%	4.2
140	Daily sales of restaurant 100011 doordash	hard	8%	3.2
141	Cumulative sales of restaurant 100011 doordash	hard	15%	4.1
142	First order date afterpay	easy	40%	4.2
143	Customer purchase report afterpay	easy	14%	2.2
144	Third order afterpay	medium	9%	4.2
145	Returning customers after first buy afterpay	hard	16%	4.2
146	Purchase by platform afterpay	easy	14%	2.2
147	2 days streak customers google	hard	13%	4.4
148	Most popular video category google	medium	13%	4.2
149	fans by video category google	easy	36%	2.2
150	Countries with above average customers google	easy	15%	3.1
151	Salary report dropbox	easy	18%	2.3
152	Salary analysis dropbox	easy	20%	2.1
153	Project ROI dropbox	easy	18%	2.2
154	Rideshare completion rate lyft	easy	25%	2.2
155	Driver with the highest cancellation rate lyft	easy	24%	2.3
156	Cancellation rate by unbanned users lyft	hard	15%	2.3
157	Number of trips before a driver got banned lyft	medium	10%	4.2
158	First trip completion rate lyft	medium	22%	4.2
159	Transaction volume from suspended accounts ebay	easy	58%	2.2
160	Sellers with no sales by day ebay	hard	11%	2.3
161	Biggest sales day ebay	easy	20%	2.2
162	Number of orders per brand walmart	easy	41%	3.1
163	Average number of orders per brand walmart	easy	32%	2.2
164	Orders distribution by brand walmart	easy	28%	2.2
165	Session stitching walmart	hard	17%	4.2
166	Top 10 customers based on spend growth walmart	medium	11%	4.2
167	Top country in video streaming tiktok	easy	28%	2.2
168	Average number of streams in the US tiktok	medium	13%	3.2
169	Same day streams tiktok	easy	34%	2.2
170	Top 3 countries by average watch time tiktok	easy	11%	2.2
171	Binge watches tiktok	easy	19%	2.2
172	Comments distribution facebook	hard	13%	3.2
173	User Popularity Percentage facebook	medium	11%	2.2
174	Closed accounts facebook	easy	23%	2.2
175	Employees' email account amazon	easy	14%	2.1
176	Employees' annual bonus amazon	easy	12%	2.3
177	Purchases by platform report amazon	medium	10%	2.3
178	Members who worked at both Microsoft and Google linkedin	medium	34%	2.3
179	Members who ever moved from Microsoft to Google linkedin	medium	31%	3.1
180	Members moved from Microsoft to Google directly. linkedin	hard	21%	4.4
181	Users who watched less than one hour of Netflix netflix	easy	19%	2.2
182	Top 5 content by number of watchers netflix	medium	9%	4.1
183	Top 5 movies by number of watchers netflix	easy	46%	2.2
184	Top 5 movies by watch time netflix	medium	16%	2.2
185	Top 5 non-English contents by watch time netflix	medium	49%	2.2
186	Average comments per question google	easy	10%	2.2
187	Comment distribution at Google Forum google	easy	17%	2.2
188	Top 1 popular question by department google	hard	14%	4.2
189	Campaign activation date twitter	medium	19%	4.1
190	Twitter campaign spend report twitter	hard	22%	2.2
191	Number of replies by group twitter	medium	18%	3.2
192	Number of replies to the original tweet by group twitter	medium	25%	2.2
193	Difference of replies by testing groups twitter	medium	33%	2.2
194	Daily active users report for new market snap	easy	20%	3.2
195	MoM user growth snap	hard	14%	4.4
196	User segments report snap	hard	18%	2.2
197	Students who didn't finish all subjects snap	easy	25%	2.2
198	Average score per subject snap	easy	50%	2.2
199	Students improvement snap	hard	67%	4.4
200	Last week's absent students snap	medium	67%	2.1
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
204	AB testing sanity check apple	easy	50%	2.2
205	Search results recall apple	medium	30%	2.2
206	Search results recall by testing group apple	medium	30%	2.2
207	Results shown rate by group apple	medium	50%	2.2
208	Top 3 urls by testing groups apple	hard	10%	4.2
209	Card issuer customers count visa	easy	100%	2.2
210	Issuer and merchant report visa	easy	100%	2.1
211	Top issuer by category visa	medium	30%	4.2
212	Highest spender's issuers visa	hard	0%	4.2
213	Interchange revenue by issuer and merchant category visa	easy	70%	3.1
214	D30 (30days) retention rate roblox	medium	20%	2.2
215	Monthly active users roblox	easy	80%	2.2
216	Most active customers roblox	hard	10%	2.2
217	Most engaged customers roblox	hard	10%	2.1
218	Total Amount Spent by Each Customer microsoft	medium	-	2.1
219	Inactive Customers in the New Year of 2024 microsoft	medium	-	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
224	Categories with High Average Product Price microsoft	medium	-	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
230	Customer Purchase Trend Analysis microsoft	easy	-	4.4

Disclaimer: SQLPad collects questions and their associated data from the internet, but we are not associated with any of the companies or organizations that may be mentioned in these questions. While we strive to provide accurate and up-to-date information, we cannot guarantee the accuracy or completeness of the information provided. Users should exercise their own discretion when using the platform and should not rely solely on the information provided. By using SQLPad, you acknowledge and agree that we are not responsible for any errors or inaccuracies in the information, and that you assume all risks associated with using the platform. You also agree to our terms and conditions.