SQLPad SQLPad Sign In

SQL Coding Questions & Answers

Practice 216 online coding questions and become a data expert.

ALL QUESTIONS

Affirm SQL Interview Questions Afterpay SQL Interview Questions Airbnb SQL Interview Questions Amazon SQL Interview Questions Doordash SQL Interview Questions Dropbox SQL Interview Questions Ebay SQL Interview Questions Google SQL Interview Questions Linkedin SQL Interview Questions Lyft SQL Interview Questions Netflix SQL Interview Questions Robinhood SQL Interview Questions Roblox SQL Interview Questions Snap SQL Interview Questions Spotify SQL Interview Questions Tiktok SQL Interview Questions Twitter SQL Interview Questions Uber SQL Interview Questions Visa SQL Interview Questions Walmart SQL Interview Questions


Level: easy

ID Title Level FTPR Lecture
1 Top store for movie sales easy
30%
2.1
2 Top 3 movie categories by sales easy
47%
2.1
3 Top 5 shortest movies easy
53%
2.1
4 Staff without a profile image easy
67%
2.1
5 Monthly revenue easy
24%
2.2
7 Unique customers count by month easy
19%
2.2
8 Average customer spend by month easy
22%
2.2
10 Min and max spend easy
13%
2.2
11 Actors' last name easy
24%
2.3
12 Actors' last name ending in 'EN' or 'RY' easy
30%
2.3
16 Staff who live in Woodridge easy
72%
2.1
17 GROUCHO WILLIAMS’ actor_id easy
65%
2.1
18 Top film category easy
25%
2.2
22 Average cost per rental transaction easy
43%
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
29%
2.3
27 Film with the largest cast easy
27%
2.3
30 Inactive customers in May easy
21%
2.3
31 Movies that have not been returned easy
27%
2.3
34 Stocked up movies easy
28%
2.3
35 Film length report easy
26%
2.3
36 Actors from film 'AFRICAN EGG' easy
36%
3.1
37 Most popular movie category easy
17%
3.1
39 Most productive actor with inner join easy
23%
3.1
46 Actors and customers whose last name starts with 'A' easy
32%
3.3
47 Actors and customers whose first names end in 'D'. easy
45%
3.3
48 Movie and TV actors easy
43%
3.1
50 Top 5 cities for movie rentals easy
23%
3.1
51 Movie only actor easy
43%
3.2
52 Movies cast by movie only actors easy
13%
3.2
56 Total number of actors easy
32%
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
14%
4.1
71 Cumulative rentals easy
18%
4.1
76 Districts with the most and least customers easy
11%
4.2
77 Movie revenue percentiles by category easy
20%
4.3
81 How many people searched on new year's day search engine easy
24%
2.2
82 The top search query on new year's day search engine easy
12%
2.2
86 Top song in the US spotify easy
19%
2.2
91 same day friend request acceptance rate spotify easy
11%
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
19%
2.2
96 Overall acceptance rate social easy
13%
2.2
97 Social influencer social easy
10%
2.2
98 Most popular user social easy
29%
2.2
101 Average number of visits per user mobile easy
12%
2.2
104 MAU: Monthly active users mobile easy
19%
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
9%
4.1
114 Dod revenue change rate amazon easy
13%
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
36%
2.2
125 Active restaurants with fewer than 5 trips per city uber easy
14%
2.2
128 Completion rate uber easy
23%
2.2
130 Newly created accounts affirm easy
34%
2.2
133 Small departments robinhood easy
44%
2.2
135 Unlucky employees robinhood easy
15%
4.2
136 Extremely late orders doordash easy
5%
2.3
138 Happy restaurants doordash easy
10%
2.3
142 First order date afterpay easy
34%
4.2
143 Customer purchase report afterpay easy
15%
2.2
146 Purchase by platform afterpay easy
13%
2.2
149 fans by video category social easy
30%
2.2
150 Countries with above average customers social easy
10%
3.1
151 Salary report dropbox easy
16%
2.3
152 Salary analysis dropbox easy
23%
2.1
153 Project ROI dropbox easy
18%
2.2
154 Rideshare completion rate lyft easy
22%
2.2
155 Driver with the highest cancellation rate lyft easy
22%
2.3
159 Transaction volume from suspended accounts ebay easy
51%
2.2
161 Biggest sales day ebay easy
19%
2.2
162 Number of orders per brand walmart easy
40%
3.1
163 Average number of orders per brand walmart easy
36%
2.2
164 Orders distribution by brand walmart easy
22%
2.2
167 Top country in video streaming tiktok easy
24%
2.2
169 Same day streams tiktok easy
29%
2.2
170 Top 3 countries by average watch time tiktok easy
10%
2.2
171 Binge watches tiktok easy
19%
2.2
174 Closed accounts social easy
18%
2.2
175 Employees' email account amazon easy
11%
2.1
176 Employees' annual bonus amazon easy
11%
2.3
181 Users who watched less than one hour of Netflix netflix easy
23%
2.2
183 Top 5 movies by number of watchers netflix easy
33%
2.2
186 Average comments per question google easy
50%
2.2
187 Comment distribution at Google Forum google easy
50%
2.2
194 Daily active users report for new market snap easy - 3.2
197 Students who didn't finish all subjects snap easy - 2.2
198 Average score per subject snap easy - 2.2
202 Monthly active paid subscriptions subscription easy - 2.2
203 Top 5 products by country by month search engine easy - 4.2
204 AB testing sanity check search engine easy - 2.2
207 Results shown rate by group search engine easy - 2.2.1
209 Card issuer customers count visa easy - 2.2
210 Issuer and merchant report visa easy - 2.1
211 High spenders by issuer visa easy - 2.1
213 Interchange revenue by issuer and merchant category visa easy - 3.2

Industry/company specific questions are sourced over the internet, however, we cannot guarantee 100% accuracy of the information provided. We strongly advise users to exercise their discretion when using the platform. By using SQLPad, you acknowledge and agree to our terms.