Given a table of hotel searches and bookings, write a query to find the top three most frequently searched destinations that resulted in zero bookings.
Use the provided search and booking tables. Exclude searches without a destination.
destination, search_countsearch_count descending, then destination ascending for ties| Column | Type | Description |
|---|---|---|
| search_idPK | INT | Unique identifier for a hotel search |
| destination | VARCHAR(100) | Destination searched by the traveler |
| searched_at | DATE | Date of the hotel search |
| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique identifier for a hotel booking |
| search_id | INT | Search associated with the booking |
| booked_at | DATE | Date of the booking |