Write a SQL query to find the top 10 most frequent items in a dataset.
Use item_events as the occurrence dataset and item_catalog for item names. Return up to 10 items that exist in the catalog and have at least one event.
item_id, item_name, and frequencyfrequency descending, then item_name ascending, then item_id ascending to break ties| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique occurrence record identifier |
| item_id | INT | Item associated with the occurrence |
| Column | Type | Description |
|---|---|---|
| item_idPK | INT | Unique item identifier |
| item_name | VARCHAR(100) | Display name of the item |