SQL Date Range Patient Query | Dataford Interview Questions

Write a SQL query to retrieve patient records from a specific date range.

Use the patient_records table and include visits from January 10, 2025 through January 20, 2025, inclusive.

Output

patient_records

Column	Type	Description
patient_idPK	INT	Unique identifier for the patient record
patient_name	VARCHAR(100)	Patient's full name
visit_date	DATE	Date associated with the patient record
diagnosis	VARCHAR(150)	Recorded diagnosis for the visit

Your question is SQL Date Range Patient Query. 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.

Write a SQL query to retrieve patient records from a specific date range.

Use the patient_records table and include visits from January 10, 2025 through January 20, 2025, inclusive.

patient_records

Column	Type	Description
patient_idPK	INT	Unique identifier for the patient record
patient_name	VARCHAR(100)	Patient's full name
visit_date	DATE	Date associated with the patient record
diagnosis	VARCHAR(150)	Recorded diagnosis for the visit

Your question is SQL Date Range Patient Query. 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.