Top Therapists by State | Dataford Interview Questions

Grow Therapy wants to identify the therapists with the highest booking volume in each state. Assume the reporting date is January 15, 2025, so the last completed quarter is October 1 through December 31, 2024.

Write a PostgreSQL query to find the top three therapists by booking volume in each state on the Grow Therapy platform.

Requirements

Count only bookings with status confirmed or completed.
Include bookings created from 2024-10-01 through 2024-12-31, inclusive.
Rank therapists independently within each non-null state and return up to three therapists per state.
Sort each state by booking volume descending, using therapist ID as a deterministic tie-breaker.

Schema

therapists

Column	Type	Description
therapist_idPK	INTEGER	Unique therapist identifier
therapist_name	VARCHAR(100)	Therapist display name
state	VARCHAR(2)	Two-letter practice state

bookings

Column	Type	Description
booking_idPK	INTEGER	Unique booking identifier
therapist_id	INTEGER	References therapists.therapist_id
booking_date	DATE	Date the booking was created
booking_status	VARCHAR(20)	Booking lifecycle status

Your question is Top Therapists by State. 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