Top Features Query | Dataford Interview Questions

Write a query to find the top 3 most frequently used features in Aveva’s software over the last 30 days, partitioned by user region.

Use the users, features, and feature_usage tables. Exclude usage records without a user region or feature, and treat tied usage counts as the same rank.

Output

One row per qualifying region and feature, with region, feature_name, usage_count, and usage_rank.
Include ranks 1 through 3, including ties, ordered by region, rank, and feature name.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
display_name	VARCHAR(100)	User display name
region	VARCHAR(50)	User geographic region

features

Column	Type	Description
feature_idPK	INT	Unique feature identifier
feature_name	VARCHAR(120)	Aveva software feature name

feature_usage

Column	Type	Description
usage_idPK	INT	Unique usage event identifier
user_id	INT	User who used the feature
feature_id	INT	Feature used in the event
used_at	TIMESTAMP	Timestamp of the feature usage event

Your question is Top Features Query. Start with the requirements and the three 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