SQL Second-Highest by Region | Dataford Interview Questions

Write a SQL query to find the second-highest energy consumption value from a log table grouped by region.

Use the energy_consumption_log table. Consider only non-null consumption values and return regions with at least two distinct values.

Output

energy_consumption_log

Column	Type	Description
log_idPK	INT	Unique log record identifier
region	VARCHAR(100)	Geographic region associated with the reading
energy_consumption	NUMERIC(12,2)	Recorded energy consumption value

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

Write a SQL query to find the second-highest energy consumption value from a log table grouped by region.

Use the energy_consumption_log table. Consider only non-null consumption values and return regions with at least two distinct values.

energy_consumption_log

Column	Type	Description
log_idPK	INT	Unique log record identifier
region	VARCHAR(100)	Geographic region associated with the reading
energy_consumption	NUMERIC(12,2)	Recorded energy consumption value

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