Tools for Healthcare Research | Dataford Interview Questions

Which statistical software or programming languages (e.g., R, SAS, SQL) are you most proficient in, and how have you applied them to healthcare research?

To demonstrate SQL proficiency, use the patients and encounters tables to identify patients with at least two emergency department encounters during 2024.

Output

One row per qualifying patient with patient_id, patient_name, ed_encounter_count, and latest_ed_encounter
Include only patients with at least two qualifying encounters
Order by encounter count descending, then latest encounter descending, then patient ID ascending

Schema

patients

Column	Type	Description
patient_idPK	INT	Unique patient identifier
patient_name	VARCHAR(100)	Patient name
birth_date	DATE	Patient date of birth
sex	VARCHAR(20)	Recorded patient sex

encounters

Column	Type	Description
encounter_idPK	INT	Unique encounter identifier
patient_id	INT	Patient associated with the encounter
encounter_date	DATE	Date of the encounter
encounter_type	VARCHAR(30)	Clinical encounter type

Your question is Tools for Healthcare Research. 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