Top Destinations by Search Volume | Dataford Interview Questions

Write a query utilizing aggregate functions and GROUP BY to find the top five travel destinations by search volume in the last 30 days.

Use the provided destination and search tables. Treat each search record as one unit of search volume and exclude searches without a recognized destination.

Output

One row per destination with columns destination_name and search_volume.
Include only the five highest-volume destinations from the last 30 days.
Order by search_volume descending, then destination_name ascending to break ties.

Schema

travel_destinations

Column	Type	Description
destination_idPK	INT	Unique identifier for a travel destination.
destination_name	VARCHAR(100)	Display name of the travel destination.

travel_searches

Column	Type	Description
search_idPK	INT	Unique identifier for a destination search.
destination_id	INT	Destination searched for, when the search was successfully associated with one.
searched_at	TIMESTAMP	Timestamp when the destination search occurred.

Your question is Top Destinations by Search Volume. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem