Rank Schools Within Districts | Dataford Interview Questions

How would you use SQL window functions to rank schools by average student score within each district?

Use the provided district, school, and student score data. Include schools with recorded scores and valid district assignments. Tied average scores must receive the same rank.

Output

One row per eligible school.
Columns: district_name, school_name, average_score, and district_rank.
Sort by district name, rank ascending, then school name.

Schema

districts

Column	Type	Description
district_idPK	INT	Unique district identifier
district_name	VARCHAR(100)	District name

schools

Column	Type	Description
school_idPK	INT	Unique school identifier
school_name	VARCHAR(150)	School name
district_id	INT	Associated district identifier

student_scores

Column	Type	Description
score_idPK	INT	Unique score record identifier
school_id	INT	School receiving the score
score	INT	Student score on the assessment

Your question is Rank Schools Within Districts. 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