Table: rental
***_**** | ***_**** --------------+-------------------------- ******_** | ******* ******_** | ********* **** **** **** *********_** | ******* ********_** | ******** ******_** | ********* **** **** **** *****_** | ********
Premium Access
Unlock this premium 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
************:
- *** ********* *** **** ** ***** 10 ***** ******* *** ***** *********, ***** * ***** ** ****** *** ***** **** *** ********* ********* ****** ***** *********:
********_** ** (1,2,3,4,5,6,7,8,9,10).- *** *** **** * ******** ** **/*** ***** ****** * ‘***** ********'.
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.
Related Questions
More ROW_NUMBER, RANK, DENSE_RANK Questions
| Question | Level | Company | FTPR |
|---|---|---|---|
| Hard | visa |
0% |
|
| Medium | visa |
30% |
|
| Hard | apple |
10% |
|
| Hard | apple |
100% |
|
| Hard | snap |
67% |
|
| Hard |
14% |
||
| Medium | walmart |
11% |
|
| Hard | walmart |
17% |
|
| Medium | lyft |
22% |
|
| Medium | lyft |
10% |
|
| Medium |
13% |
||
| Hard | afterpay |
16% |
|
| Medium | afterpay |
9% |
|
| Easy | afterpay |
40% |
|
| Medium | doordash |
17% |
|
| Medium | doordash |
9% |
|
| Easy | robinhood |
16% |
|
| Hard | uber |
11% |
|
|
#123. Top listing in the United States, United Kingdom and Canada |
Medium | airbnb |
10% |
| Hard | airbnb |
13% |
|
| Hard | airbnb |
10% |
|
| Hard | airbnb |
10% |
|
| Easy | amazon |
14% |
|
| Medium | amazon |
12% |