Basic SQL Interview Questions

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

ALL QUESTIONS

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
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
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.