Chapter 2: Single Table Operation


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
6 Daily revenue in June, 2020 medium
11%
2.2
7 Unique customers count by month easy
19%
2.2
8 Average customer spend by month easy
22%
2.2
9 Number of high spend customers by month medium
4%
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
13 Actors' first name medium
13%
2.3
14 Good days and bad days hard
4%
2.3
15 Fast movie watchers vs slow watchers hard
5%
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
19 Most productive actor medium
14%
2.2
20 Customer who spent the most medium
15%
2.2
21 Customer who rented the most medium
20%
2.2
22 Average cost per rental transaction easy
43%
2.3
23 Average spend per customer in Feb 2020 easy
16%
2.2
24 Films with more than 10 actors medium
20%
2.3
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
28 Film with the second largest cast medium
25%
2.3
29 Second highest spend customer medium
16%
2.3
30 Inactive customers in May easy
21%
2.3
31 Movies that have not been returned easy
27%
2.3
32 Unpopular movies hard
16%
2.3
33 Returning customers medium
8%
2.3
34 Stocked up movies easy
28%
2.3
35 Film length report easy
26%
2.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
84 Click through rate on new year's day search engine medium
10%
2.2
85 Top 4 queries based on click through rate on new year's day search engine hard
6%
2.2
86 Top song in the US spotify easy
19%
2.2
89 Top 5 artists in the US spotify medium
11%
2.2
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
95 Candidate products for subscription amazon hard
11%
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
102 Histogram by visit session duration mobile hard
12%
2.3
106 Mobile vs. web mobile medium
9%
2.2
107 Customer count by platform mobile medium
19%
2.2
111 Second most popular product amazon medium
14%
2.1
112 Top 3 customers amazon easy
30%
2.2
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
126 Top 3 restaurants uber hard
9%
2.1
128 Completion rate uber easy
23%
2.2
130 Newly created accounts affirm easy
34%
2.2
131 Churned accounts affirm hard
10%
2.3
132 Top 3 trending countries affirm medium
8%
2.2
133 Small departments robinhood easy
44%
2.2
134 Expensive departments robinhood medium
32%
2.2
136 Extremely late orders doordash easy
5%
2.3
138 Happy restaurants doordash easy
10%
2.3
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
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
156 Cancellation rate by unbanned users lyft hard
14%
2.3
159 Transaction volume from suspended accounts ebay easy
51%
2.2
160 Sellers with no sales by day ebay hard
7%
2.3
161 Biggest sales day ebay easy
19%
2.2
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
173 User Popularity Percentage social medium
5%
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
177 Purchases by platform report amazon medium
9%
2.3
178 Members who worked at both Microsoft and Google linkedin medium
36%
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
184 Top 5 movies by watch time netflix medium
7%
2.2
185 Top 5 non-English contents by watch time netflix medium
53%
2.2
186 Average comments per question google easy
50%
2.2
187 Comment distribution at Google Forum google easy
50%
2.2
190 Twitter campaign spend report twitter hard
50%
2.2
192 Number of replies to the original tweet by group twitter medium
100%
2.2
193 Difference of replies by testing groups twitter medium
100%
2.2
196 User segments report snap hard - 2.2
197 Students who didn't finish all subjects snap easy - 2.2
198 Average score per subject snap easy - 2.2
200 Last week's absent students snap medium - 2.1
202 Monthly active paid subscriptions subscription easy - 2.2
204 AB testing sanity check search engine easy - 2.2
205 Search results recall search engine medium - 2.2
206 Search results recall by testing group search engine medium - 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
212 Top issuing bank by category visa hard - 2.1
214 D30 retention rate gaming hard - 2.2
215 Monthly active users gaming hard - 2.2
216 Highest spender gaming hard - 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.