68. Spend difference between first and second 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%
79 Spend difference between the last and the second last rentals hard
16%
69 Number of happy customers hard
7%