Basic SQL Interview Questions

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

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

Level: easy

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
7	Unique customers count by month	easy	18%	2.2
8	Average customer spend by month	easy	20%	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
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
22	Average cost per rental transaction	easy	42%	2.3
23	Average spend per customer in Feb 2020	easy	16%	2.2
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
30	Inactive customers in May	easy	22%	2.3
31	Movies that have not been returned	easy	26%	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
39	Most productive actor with inner join	easy	22%	3.1
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
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
56	Total number of actors	easy	30%	3.2
57	Total number of actors (with UNION)	easy	37%	3.3
65	Movie revenue percentiles	easy	16%	4.3
67	Quartile by number of rentals	easy	24%	4.3
70	Cumulative spend	easy	13%	4.1
71	Cumulative rentals	easy	21%	4.1
76	Districts with the most and least customers	easy	12%	4.2
77	Movie revenue percentiles by category	easy	18%	4.3
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
86	Top song in the US spotify	easy	18%	2.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
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
101	Average number of visits per user google	easy	14%	2.2
104	MAU: Monthly active users google	easy	20%	3.3
109	Top 3 most popular product categories amazon	easy	11%	4.2
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
116	Top answers day by device amazon	easy	14%	4.2
117	Rolling 7 days total answers amazon	easy	35%	4.1
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
128	Completion rate uber	easy	26%	2.2
130	Newly created accounts affirm	easy	37%	2.2
133	Small departments robinhood	easy	45%	2.2
135	Unlucky employees robinhood	easy	16%	4.2
136	Extremely late orders doordash	easy	11%	2.3
138	Happy restaurants doordash	easy	14%	2.3
142	First order date afterpay	easy	40%	4.2
143	Customer purchase report afterpay	easy	14%	2.2
146	Purchase by platform afterpay	easy	14%	2.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
159	Transaction volume from suspended accounts ebay	easy	58%	2.2
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
167	Top country in video streaming tiktok	easy	28%	2.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
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
181	Users who watched less than one hour of Netflix netflix	easy	19%	2.2
183	Top 5 movies by number of watchers netflix	easy	46%	2.2
186	Average comments per question google	easy	10%	2.2
187	Comment distribution at Google Forum google	easy	17%	2.2
194	Daily active users report for new market snap	easy	20%	3.2
197	Students who didn't finish all subjects snap	easy	25%	2.2
198	Average score per subject snap	easy	50%	2.2
204	AB testing sanity check apple	easy	50%	2.2
209	Card issuer customers count visa	easy	100%	2.2
210	Issuer and merchant report visa	easy	100%	2.1
213	Interchange revenue by issuer and merchant category visa	easy	70%	3.1
215	Monthly active users roblox	easy	80%	2.2

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.