SQL for Top Patient Satisfaction | Dataford Interview Questions

Write a SQL query to find the top five hospitals with the highest patient satisfaction ratings.

Use the provided hospital and patient satisfaction survey data. Include only hospitals with at least one non-null rating.

Output

One row per hospital with columns hospital_name and average_satisfaction_rating.
Return the five highest average ratings, ordered descending. Break ties by hospital_id ascending.

hospitals

patient_satisfaction_surveys

Column	Type	Description
survey_idPK	INT	Unique survey identifier
hospital_id	INT	Hospital associated with the survey
rating	INT	Patient satisfaction rating from 1 to 5
survey_date	DATE	Date the survey was completed

Your question is SQL for Top Patient Satisfaction. 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 top five hospitals with the highest patient satisfaction ratings.

Use the provided hospital and patient satisfaction survey data. Include only hospitals with at least one non-null rating.

One row per hospital with columns hospital_name and average_satisfaction_rating.
Return the five highest average ratings, ordered descending. Break ties by hospital_id ascending.

hospitals

patient_satisfaction_surveys

Column	Type	Description
survey_idPK	INT	Unique survey identifier
hospital_id	INT	Hospital associated with the survey
rating	INT	Patient satisfaction rating from 1 to 5
survey_date	DATE	Date the survey was completed

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