SQL Conditional Retrieval | Dataford Interview Questions

Write a SQL query to retrieve data from a table based on a condition.

Use the appointments table and return only records whose status is Completed. Include the requested columns and present the matching appointments in chronological order, with appointment ID resolving ties.

Output

One row per completed appointment.
Columns: appointment_id, patient_name, status, and appointment_date.
Sort by appointment_date ascending, then appointment_id ascending.

Schema

appointments

Column	Type	Description
appointment_idPK	INT	Unique appointment identifier
patient_name	VARCHAR(100)	Patient name
status	VARCHAR(30)	Appointment status
appointment_date	DATE	Scheduled appointment date
provider_name	VARCHAR(100)	Assigned provider

Your question is SQL Conditional Retrieval. 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

Write a SQL query to retrieve data from a table based on a condition.

Output

One row per completed appointment.
Columns: appointment_id, patient_name, status, and appointment_date.
Sort by appointment_date ascending, then appointment_id ascending.

Schema

appointments

Column	Type	Description
appointment_idPK	INT	Unique appointment identifier
patient_name	VARCHAR(100)	Patient name
status	VARCHAR(30)	Appointment status
appointment_date	DATE	Scheduled appointment date
provider_name	VARCHAR(100)	Assigned provider

Your question is SQL Conditional Retrieval. 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.