Top Feature SQL Query | Dataford Interview Questions

Write a SQL query to find the top-performing product or feature by a chosen metric.

Use the supplied catalog and usage records. Treat successful usage during January 2025 as the metric, and consider only active catalog entries.

Output

Return one row per top-performing item, with item_name, item_type, and successful_usage_count.
Include every item tied for the highest count.
Order tied results by item_name ascending.

catalog_items

Column	Type	Description
item_idPK	INT	Unique catalog item identifier
item_name	VARCHAR(150)	Product or feature name
item_type	VARCHAR(30)	Whether the catalog item is a product or feature
is_active	BOOLEAN	Whether the item should be considered

usage_events

Column	Type	Description
event_idPK	INT	Unique usage event identifier
item_id	INT	Catalog item associated with the event
occurred_at	TIMESTAMP	Time when the usage occurred
event_status	VARCHAR(30)	Event outcome

Your question is Top Feature SQL Query. 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.