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) -- ******, *******