SQL Interview Questions

Practice 180 online SQL coding questions and ace your data job interview.

Nervous about your SQL interview? Try instamentor and hire a FAANG mentor for 1:1 job interview coaching.

ALL QUESTIONS

Affirm SQL Interview Questions Airbnb SQL Interview Questions Afterpay SQL Interview Questions Amazon SQL Interview Questions Doordash SQL Interview Questions Dropbox SQL Interview Questions Ebay SQL Interview Questions Facebook SQL Interview Questions Google SQL Interview Questions Linkedin SQL Interview Questions Lyft SQL Interview Questions Robinhood SQL Interview Questions Spotify SQL Interview Questions Tiktok SQL Interview Questions Uber SQL Interview Questions Walmart SQL Interview Questions

Chapter 4: Window Functions

ID Title Level FTPR Lecture
58 Percentage of revenue per movie hard
5%
4.1
59 Percentage of revenue per movie by category medium
9%
4.1
60 Movie rentals and average rentals in the same category hard
5%
4.1
61 Customer spend vs average spend in the same store hard
7%
4.1
62 Shortest film by category medium
9%
4.2
63 Top 5 customers by store hard
5%
4.2
64 Top 2 films by category hard
11%
4.2
65 Movie revenue percentiles easy
13%
4.3
66 Movie percentiles by revenue by category medium
15%
4.3
67 Quartile by number of rentals easy
22%
4.3
68 Spend difference between first and second rentals hard
12%
4.4
69 Number of happy customers hard
17%
4.4
70 Cumulative spend easy
11%
4.1
71 Cumulative rentals easy
17%
4.1
72 Days when they became happy customers easy
15%
4.2
73 Number of days to become a happy customer medium
10%
4.2
74 The most productive actors by category hard
7%
4.2
75 Top customer by movie category medium
21%
4.2
76 Districts with the most and least customers easy
12%
4.2
77 Movie revenue percentiles by category easy
20%
4.3
78 Quartiles buckets by number of rentals medium
14%
4.3
79 Spend difference between the last and the second last rentals hard
18%
4.4
80 DoD revenue growth for each store hard
16%
4.4
83 Top search_query in US and UK on new year's day facebook medium
8%
4.2
88 Top song report spotify medium
25%
4.2
90 Top artist report spotify medium
11%
4.2
103 Median and average session duration by day of the week google medium
13%
4.3
105 Number of days gap between last two actions google hard
20%
4.2
108 Free amazon prime membership amazon hard
14%
4.1
109 Top 3 most popular product categories amazon easy
18%
4.2
110 Most popular product by category amazon medium
15%
4.2
113 Daily cumulative spend amazon easy
0%
4.1
114 Dod revenue change rate amazon easy
15%
4.4
115 Rolling average revenue amazon hard
22%
4.1
116 Top answers day by device amazon easy
27%
4.2
117 Rolling 7 days total answers amazon easy
27%
4.1
119 Top 3 countries by bookings airbnb hard
11%
4.2
120 First ever booking airbnb hard
13%
4.2
121 Week over week change of first ever bookings airbnb hard
0%
4.4
122 Top 3 countries by wow growth airbnb hard
33%
4.2
123 Top 10 listings in Australia, United Kingdom and Canada airbnb medium
20%
4.2
127 Average rating after 10th trip uber hard
0%
4.2
135 Unlucky employees robinhood easy
0%
4.2
137 Extremely late first orders doordash medium
33%
4.2
139 Poor first delivery experience doordash medium
100%
4.2
141 Cumulative sales of restaurant 100011 doordash hard
50%
4.1
142 First order date afterpay easy
0%
4.2
144 Third order afterpay medium
100%
4.2
145 Returning customers after first buy afterpay hard
50%
4.2
147 2 days streak customers tiktok hard
25%
4.4