Second-Highest Per Region Query | Dataford Interview Questions

Write a SQL query to return the second-highest value in each region using window functions.

Use the regional_values table. Return only regions with at least two distinct non-null values. If multiple records share the second-highest value, return that value once.

Output

One row per qualifying region, with columns region and second_highest_value.
Sort the results by region in ascending order.

Schema

regional_values

Column	Type	Description
value_idPK	INT	Unique identifier for the regional value record
region	VARCHAR(50)	Region associated with the value
metric_value	DECIMAL(12,2)	Numeric value to rank within each region

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

Problem