Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rank Providers by Monthly Volume

Medium
SQL & Data ManipulationWindow FunctionsRankingAggregations
Asked 2mo ago|
Zocdoc
Zocdoc
Asked 1 times

Problem

Write a query using window functions to rank healthcare providers based on their monthly booking volume within each geographic region for Zocdoc.

Practicing as: Business Analyst interview at Zocdoc

Hi, I'll play your Zocdoc interviewer for the Business Analyst role. Candidates describe these interviews as often stressful and moderately difficult, so expect me to be direct and to the point. Take your time with the question above and answer like we're in the room.

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
Zocdoc Business Analyst Interview QuestionsZocdoc Interview Questions
Next questions
Lyra HealthTop Providers by Monthly SessionsMediumMSDSQL for Top Prescribers by RegionMediumGarner healthSQL Window Ranking by RegionMedium