Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rank Schools Within Districts

Medium
SQL & Data ManipulationWindow FunctionsRankingAggregationsAsked 1 times

Problem

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

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
The College Board Data Scientist Interview Questions
Next questions
The College BoardRank Students with Window FunctionsMediumSuccess Academy Charter SchoolsRank Schools With Window FunctionsHardTTTWindow Functions for RankingMedium
0 / ~200 words