Table: alexa_answers
****** ** ******* ***** ******** ** **** *** ******.
***_**** | ***_**** --------------+------------- **** | **** ****** | *******(20) ******* | ******
Question 117
Rolling 7 days total answers
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 ***** ** ***3 **** ******* *-1 ********* *** ******* ***)
- ** ***** ****'* 7 **** ****** * ***, *** *** **** *********.
- *** **********, ** ****** ***** **** ** ***** *** ***** ***** ***.
Sample results
Last Submission
postgresNo 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.
Interview timer
Recommended interview pacing
Easy: 5 min for direct warm-up style questions.
Medium: 10 min for multi-step interview queries.
Hard: 15 min for layered questions with tighter time pressure.
A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.
5:00
Your results
Run your query to preview results here.