75. Top customer by movie category

medium

***********

  • ******************************************************************************
  • ******************************************

****

  • ******************************************************************************************************************************
******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

Table 1: film


**********************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

Table 2: film_category

**************************************


*******************************************************************************************************************

Table 3: inventory

*****************************************************************


************************************************************************************************************************************************

Table 4: payment

***************************************


********************************************************************************************************************************************************************************************************************************************

Table 5: rental


*************************************************************************************************************************************************************************************************************************************************************

Sample results




Last Submission postgres

Expected results



More ROW_NUMBER, RANK, DENSE_RANK questions

ID Title Level FTPR
212 Highest spender's issuers visa hard
0%
211 Top issuer by category visa medium
30%
208 Top 3 urls by testing groups apple hard
10%
203 Top product by country by month apple hard
100%
201 Top 3 students for each subject snap hard
67%
188 Top 1 popular question by department google hard
14%
166 Top 10 customers based on spend growth walmart medium
11%
165 Session stitching walmart hard
17%
158 First trip completion rate lyft medium
22%
157 Number of trips before a driver got banned lyft medium
10%
148 Most popular video category google medium
13%
145 Returning customers after first buy afterpay hard
16%
144 Third order afterpay medium
9%
142 First order date afterpay easy
40%
139 Poor first delivery experience doordash medium
17%
137 Extremely late first orders doordash medium
9%
135 Unlucky employees robinhood easy
16%
127 Average rating after 10th trip uber hard
11%
123 Top listing in the United States, United Kingdom and Canada airbnb medium
10%
122 Top country by wow growth airbnb hard
13%
120 First ever booking airbnb hard
10%
119 Top 2 countries by bookings airbnb hard
10%
116 Top answers day by device amazon easy
14%
110 Most popular product by category amazon medium
12%
109 Top 3 most popular product categories amazon easy
11%
105 Number of days gap between last two actions google hard
8%
90 Top artist report spotify medium
21%
88 Top song report spotify medium
22%
83 Top search_query in US and UK on new year's day facebook medium
6%
76 Districts with the most and least customers easy
12%
74 The most productive actors by category hard
7%
73 Number of days to become a happy customer hard
11%
72 Days when they became happy customers medium
10%
64 Top 2 films by category hard
14%
63 Top 5 customers by store hard
8%
62 Shortest film by category medium
8%