Question 79

Spend difference between the last and the second last rentals

Premium Access

Unlock this premium interview question.

Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.

  • 230+ interview questions
  • Official solutions
  • SQL, Python, and R tracks
************
  • ***** * ***** ** ****** *** ***** ****** ********** ******* *** **** *** *** ****** **** ***** ******* *** *** ********* *********:
  • ********_** ** (1,2,3,4,5,6,7,8,9,10).
  • **** ********* ** **** **** **** **** 2 *******.
****
  • *** ***_****** ** ********* *** ******** ** ***** ******

Table: payment

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

   ***_****   | ***_****
--------------+--------------------------
 *******_**   | *******
 ********_**  | ********
 *****_**     | ********
 ******_**    | *******
 ******       | *******
 *******_**   | ********* **** **** ****

Sample results


        
    

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Copied
Expected results

Submit a query to compare against expected output.