Table: amzn_employees
***_**** | ***_**** -------------+------------------ ********_** | ****** *****_**** | **** ****_**** | **** ******_**** | **** ****** | *****
Question 176
Employees' annual bonus
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
- ***** * ***** ** ******* **** ****'* ****** ***** ***** ** *** ********* *****:
- ****** *** ****** ****** ***** 2021-05-01 ******** *******.
- ***** *** ****** ****** 2021-01-01 ******* * **** ***** ** 10000.
- *** ***** *** ****** ****** 2021-05-01 *** ***** 2021-01-01, ***** ****** ***** ** ******** ** *** ****** ** **** ******* ***** ****** **** *** 2021-05-01, ******* ** 120 *** ******** ** 10,000.
- ****** 3 *******: *****_****, ****_****, *** *****.
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.