Table 1: song
***_**** | ***_**** -------------+-------------------------- ****_** | ****** ***** | *******(1000) ******_** | ******
Question 88
Top song report
Premium Access
Unlock this Spotify 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 **** ** 2021: 2021-01-01 - 2021-01-07
- ****** * ****** *** *** **** *******
- *** **********, ***'* ****** ***** ** ** ***.
- *** ***** ** **** ******* *****'* ******.
Table 2: song_plays
****** ** ***** * **** ** ****** (********), ********** ** ***** *****.
***_**** | ***_**** -------------+-------------------------- **** | **** ******* | *******(2) ****_** | ****** ***_***** | ******
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.
10:00
Your results
Run your query to preview results here.