Top-Decile Utilization SQL | Dataford Interview Questions

Extract top-decile utilizing members using CTEs and ranking window functions.

Use the members and utilization_events tables. Calculate utilization from event units, include members with no events, and assign the highest-utilization decile deterministically.

Output

One row per member in the highest utilization decile.
Columns: member_id, member_name, utilization_events, total_utilization_units, utilization_rank, and utilization_decile.
Order by total_utilization_units descending, then member_id ascending.

Schema

members

Column	Type	Description
member_idPK	INT	Unique member identifier
member_name	VARCHAR(100)	Member display name

utilization_events

Column	Type	Description
event_idPK	INT	Unique utilization event identifier
member_id	INT	Member associated with the event
service_date	DATE	Date of the utilization event
utilization_units	INT	Units attributed to the event

Your question is Top-Decile Utilization SQL. 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