Question 113

Daily cumulative spend

Premium Access

Unlock this Amazon 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
  • ***** * ***** ** ****** ***** ********** ***** *** *********:
    • ********_*** = [1008, 1021, 1028, 1033, 1030, 1038]
  • **** **** 2021-08-01 ** 2021-08-10 (*********).
  • ***** *** ** ****** ****** 2021-08-01.

Table: orders

** ********* *******'* ****** ***** *****.

  ***_****    | ***_****
--------------+-------------------
*****_**      | ******
*******_**    | ******
********_**   | ******
*****_**      | ****
***           | *******
****_*****_***| *****
*******       | *******(20) -- ******, *******

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.