Write a SQL query to find the top 10 most booked hotels in the past year for Marriott International.
Use the hotel and booking records provided. Count bookings dated from one year before the current date through the current date.
hotel_id, hotel_name, and booking_countbooking_count descending, then hotel_id ascending for ties| Column | Type | Description |
|---|---|---|
| hotel_idPK | INT | Unique identifier for the hotel |
| hotel_name | VARCHAR(150) | Marriott hotel property name |
| brand | VARCHAR(80) | Marriott brand associated with the property |
| city | VARCHAR(100) | City where the hotel is located |
| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique identifier for the booking |
| hotel_id | INT | Hotel associated with the booking |
| booked_at | DATE | Date when the booking was recorded |