SQL Window Functions | Dataford Interview Questions

How would you write an SQL query using window functions to solve a risk or analytics problem?

Use the provided risk_events and desks tables. Calculate positive account exposure for January 2025 and rank accounts within each region, excluding non-positive totals and unmatched desk records.

Output

One row per qualifying region, desk, and account.
Columns: region, desk_name, account_id, total_exposure, and exposure_rank.
Sort by region, exposure rank ascending, desk name, and account ID.

Schema

desks

Column	Type	Description
desk_idPK	INT	Unique desk identifier
desk_name	VARCHAR(100)	Desk name
region	VARCHAR(50)	Reporting region

risk_events

Column	Type	Description
event_idPK	INT	Unique risk event identifier
desk_id	INT	Referenced desk identifier
account_id	VARCHAR(30)	Risk account identifier
event_date	DATE	Date of the risk event
exposure	DECIMAL(12,2)	Exposure amount for the event

Your question is SQL Window Functions. 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