Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Tests Per Department Query

Medium
SQL & Data ManipulationWindow FunctionsRankingAggregationsAsked 1 times

Problem

Given a schema of medical tests and results, write a query to find the top three most frequently ordered tests per hospital department.

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
Tempus AI Software Engineer Interview QuestionsTempus AI Interview Questions
Next questions
Hyundai Autoever AmericaTop Salaries Per DepartmentMediumGustoTop Departments QueryMediumPartners ConsultingTop Billing Codes by DepartmentMedium
0 / ~200 words