Complex 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
14 Good days and bad days hard
4%
2.3
15 Fast movie watchers vs slow watchers hard
6%
2.3
32 Unpopular movies hard
17%
2.3
41 Productive actors vs less-productive actors hard
7%
3.2
45 Movie inventory optimization hard
9%
3.2
53 Movie groups by rental income hard
11%
3.2
58 Percentage of revenue per movie hard
8%
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
63 Top 5 customers by store hard
8%
4.2
64 Top 2 films by category hard
14%
4.2
68 Spend difference between first and second rentals hard
12%
4.4
69 Number of happy customers hard
7%
4.4
73 Number of days to become a happy customer hard
11%
4.2
74 The most productive actors by category hard
7%
4.2
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
85 Top 4 queries based on click through rate on new year's day facebook hard
7%
2.2
95 Candidate products for subscription amazon hard
13%
2.2
102 Histogram by visit session duration google hard
17%
2.3
105 Number of days gap between last two actions google hard
8%
4.2
108 Free premium membership amazon hard
16%
4.1
115 Rolling average revenue amazon hard
28%
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
126 Top 3 restaurants uber hard
10%
2.1
127 Average rating after 10th trip uber hard
11%
4.2
131 Churned accounts affirm hard
10%
2.3
140 Daily sales of restaurant 100011 doordash hard
8%
3.2
141 Cumulative sales of restaurant 100011 doordash hard
15%
4.1
145 Returning customers after first buy afterpay hard
16%
4.2
147 2 days streak customers google hard
13%
4.4
156 Cancellation rate by unbanned users lyft hard
15%
2.3
160 Sellers with no sales by day ebay hard
11%
2.3
165 Session stitching walmart hard
17%
4.2
172 Comments distribution facebook hard
13%
3.2
180 Members moved from Microsoft to Google directly. linkedin hard
21%
4.4
188 Top 1 popular question by department google hard
14%
4.2
190 Twitter campaign spend report twitter hard
22%
2.2
195 MoM user growth snap hard
14%
4.4
196 User segments report snap hard
18%
2.2
199 Students improvement snap hard
67%
4.4
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
208 Top 3 urls by testing groups apple hard
10%
4.2
212 Highest spender's issuers visa hard
0%
4.2
216 Most active customers roblox hard
10%
2.2
217 Most engaged customers roblox hard
10%
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
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

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.