SQL Average Age Query | Dataford Interview Questions

Write a SQL query to find the average age of patients in a dataset.

Use the patients table and return one result for all patients. Missing age values should not affect the calculated average.

Output

patients

Column	Type	Description
patient_idPK	INT	Unique patient identifier
age	INT	Patient age in years

Your question is SQL Average Age 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 find the average age of patients in a dataset.

Use the patients table and return one result for all patients. Missing age values should not affect the calculated average.

patients

Column	Type	Description
patient_idPK	INT	Unique patient identifier
age	INT	Patient age in years

Your question is SQL Average Age 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.