58. Percentage of revenue per movie

hard

***********

  • ************************************************************************************************.
  • ************************************************************.
  • *****************************************

Table 1: inventory

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


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

Table 2: payment

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


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

Table 3: rental


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

Sample results




Last Submission postgres

Expected results



More AVG, MIN/MAX, SUM questions

ID Title Level FTPR
189 Campaign activation date twitter medium
19%
182 Top 5 content by number of watchers netflix medium
9%
141 Cumulative sales of restaurant 100011 doordash hard
15%
117 Rolling 7 days total answers amazon easy
35%
115 Rolling average revenue amazon hard
28%
113 Daily cumulative spend amazon easy
11%
108 Free premium membership amazon hard
16%
71 Cumulative rentals easy
21%
70 Cumulative spend easy
13%
61 Customer spend vs average spend in the same store hard
11%
60 Movie rentals and average rentals in the same category hard
9%
59 Percentage of revenue per movie by category medium
6%