61. Customer spend vs average spend in the same store

hard

***********

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

****

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

Table 1: customer


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

Table 2: payment

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


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

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%
60 Movie rentals and average rentals in the same category hard
9%
59 Percentage of revenue per movie by category medium
6%
58 Percentage of revenue per movie hard
8%