Write a SQL query to find the top 10 most visited destinations from a travel dataset.
Use the destination and visit records to count visits for each destination. Exclude visits that cannot be associated with a destination.
destination_name and visit_count.| Column | Type | Description |
|---|---|---|
| destination_idPK | INT | Unique destination identifier |
| destination_name | VARCHAR(100) | Destination name |
| country | VARCHAR(100) | Country containing the destination |
| Column | Type | Description |
|---|---|---|
| visit_idPK | INT | Unique visit identifier |
| destination_id | INT | Destination associated with the visit |
| visited_at | DATE | Date of the visit |