Second-Highest in Grouped Data | Dataford Interview Questions

How would you use SQL to find the second-highest value in a grouped dataset?

Write a PostgreSQL query using the provided grouped observations and group metadata. Treat the second-highest value as the second-highest distinct aggregate, and return all groups tied at that level.

Output

Return group_name and grouped_value.
Include one row per matching group and exclude groups without observations.
Sort by grouped_value descending, then group_name ascending.

Schema

groups

Column	Type	Description
group_idPK	INT	Unique identifier for a group
group_name	VARCHAR(100)	Readable group name

observations

Column	Type	Description
observation_idPK	INT	Unique observation identifier
group_id	INT	Group associated with the observation
amount	NUMERIC(12,2)	Numeric value included in the group aggregate

Your question is Second-Highest in Grouped Data. 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.

Problem