Top 5 Features by Time-Series Metric | Dataford Interview Questions

Write a SQL query to identify the top 5 performing features based on a specific time-series metric.

Assume feature_daily_metrics contains one row per feature and date, with metric_value as the metric. Consider active features across all available dates.

Output

Return one row per feature with feature_id, feature_name, and average_metric_value.
Include the five highest averages, ordered descending, with feature_id ascending as the tie-breaker.

Schema

feature_catalog

Column	Type	Description
feature_idPK	INT	Unique feature identifier
feature_name	VARCHAR(100)	Feature display name
is_active	BOOLEAN	Whether the feature is currently active

feature_daily_metrics

Column	Type	Description
metric_idPK	INT	Unique metric observation identifier
feature_id	INT	Referenced feature identifier
metric_date	DATE	Date of the metric observation
metric_value	DECIMAL(10,2)	Time-series metric value for the feature and date

Your question is Top 5 Features by Time-Series Metric. 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