Interview Questions
Interview Guides
Experiences
Explore
Get started
Sign in
Interview Guides
All questions
/
SQL & Data Manipulation
Top Hotels Per City Query
Medium
Asked at 1 company
Joins
Ranking
Aggregations
Problem
Write a query to find the top 3 most booked hotels in each city for the last 30 days.
Question
Answer
Problem
Write a query to find the top 3 most booked hotels in each city for the last 30 days.
Your answer
Edit
Preview
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
0 words
target ~200
Try a free preview
Stuck? Get a hint
Past attempts
Up next
Top Cities Booking Conversion SQL
Medium
SQL Ranking by Satisfaction
Hard
Top 3 Products Per Category
Hard
Next question
Top Hotels Per City Query | Dataford Interview Questions
