SQL for Patient Satisfaction Averages | Dataford Interview Questions

Write a SQL query to find the average patient satisfaction score by department.

Use the provided department and patient satisfaction survey data. Include departments with no recorded scores, returning NULL for their average.

Output

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

patient_satisfaction_surveys

Column	Type	Description
survey_idPK	INT	Unique survey identifier
department_id	INT	Department associated with the survey
satisfaction_score	DECIMAL(3,2)	Patient satisfaction score from 1.00 to 5.00

Your question is SQL for Patient Satisfaction Averages. 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.

Write a SQL query to find the average patient satisfaction score by department.

Use the provided department and patient satisfaction survey data. Include departments with no recorded scores, returning NULL for their average.

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

patient_satisfaction_surveys

Column	Type	Description
survey_idPK	INT	Unique survey identifier
department_id	INT	Department associated with the survey
satisfaction_score	DECIMAL(3,2)	Patient satisfaction score from 1.00 to 5.00

Your question is SQL for Patient Satisfaction Averages. 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.