Question 115

Rolling average revenue

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
  • *** **** *** ******* *** ******* 7 **** ******* *******
  • ******* 7 ****: 6 **** ****** + **** ***
  • ****: * **** ******* ******* ****** ** ******** ******
    • ***(***1) ****(***** ** ***2 **** ******* *-1 ********* *** ******* ***)
  • ** ***** ****'* 7 **** ****** * ***, *** *** **** *********.
  • *** **********, ** ****** ***** **** ** ***** *** ***** ***** ***.

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.