SQL for 30-Day Virtual Consult Counts | Dataford Interview Questions

Write a SQL query to identify patients who have had more than a specific number of virtual consultations within a thirty-day window.

Assume the specific threshold is more than three completed virtual consultations. A thirty-day window is inclusive of consultations occurring exactly thirty days apart.

Output

Return one row per qualifying patient.
Include patient_id and patient_name.
Sort by patient_id in ascending order.

Schema

patients

Column	Type	Description
patient_idPK	INT	Unique patient identifier
patient_name	VARCHAR(100)	Patient's display name

consultations

Column	Type	Description
consultation_idPK	INT	Unique consultation identifier
patient_id	INT	Patient associated with the consultation
consultation_at	TIMESTAMP	Consultation start timestamp
modality	VARCHAR(20)	Consultation modality, such as virtual or in_person
status	VARCHAR(20)	Consultation status

Your question is SQL for 30-Day Virtual Consult Counts. 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