SQL Query for Patient Condition | Dataford Interview Questions

Boston Children's Hospital analysts use a de-identified clinical data warehouse to prepare condition-specific patient cohorts. Write a PostgreSQL query to extract patients whose recorded primary condition is Asthma.

Requirements

Return the patient ID, patient name, date of birth, and primary condition.
Include only exact matches for primary_condition = 'Asthma', and order the results by patient_id ascending.

Schema

patients

Column	Type	Description
patient_idPK	INTEGER	Unique de-identified patient identifier
patient_name	VARCHAR(100)	De-identified patient name
date_of_birth	DATE	Patient date of birth
primary_condition	VARCHAR(100)	Recorded primary medical condition

Your question is SQL Query for Patient Condition. Start with the requirements and the one table 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

Requirements

Return the patient ID, patient name, date of birth, and primary condition.
Include only exact matches for primary_condition = 'Asthma', and order the results by patient_id ascending.

Schema

patients

Column	Type	Description
patient_idPK	INTEGER	Unique de-identified patient identifier
patient_name	VARCHAR(100)	De-identified patient name
date_of_birth	DATE	Patient date of birth
primary_condition	VARCHAR(100)	Recorded primary medical condition

Your question is SQL Query for Patient Condition. Start with the requirements and the one table 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.