79. Spend difference between the last and the second last rentals

hard

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

Table: payment

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


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

Sample results




Last Submission postgres

Expected results



More LAG, LEAD questions

ID Title Level FTPR
230 Customer Purchase Trend Analysis microsoft easy -
229 Time Between Repeat Purchases microsoft hard -
199 Students improvement snap hard
67%
195 MoM user growth snap hard
14%
180 Members moved from Microsoft to Google directly. linkedin hard
21%
147 2 days streak customers google hard
13%
121 Week over week change of first ever bookings airbnb hard
14%
114 Dod revenue change rate amazon easy
15%
80 DoD revenue growth for each store hard
19%
69 Number of happy customers hard
7%
68 Spend difference between first and second rentals hard
12%