Second-Highest Satisfaction by Region | Dataford Interview Questions

Write a query to find the second-highest patient satisfaction score within each operational region.

Treat scores as distinct values, so tied scores should produce one result per region. Ignore NULL scores and exclude regions without at least two distinct non-NULL scores.

Output

One row per qualifying operational region
Columns: operational_region, second_highest_score
Sort by operational_region ascending

Schema

patient_satisfaction_surveys

Column	Type	Description
survey_idPK	INT	Unique identifier for the satisfaction survey
operational_region	VARCHAR(50)	Operational region associated with the survey
satisfaction_score	INT	Patient satisfaction score on a 0 to 5 scale

Your question is Second-Highest Satisfaction by Region. 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