Second-Highest Revenue SQL | Dataford Interview Questions

Write an SQL query to find the second-highest sales revenue generated by a retail store in a specific region.

Use Southeast as the target region for the provided data. Include every store tied at the second-highest revenue level, and treat stores without sales as having zero revenue.

Output

Return one row per qualifying store with store_id, store_name, and total_revenue.
Include only stores ranked second by distinct revenue within the target region.
Order by total_revenue descending, then store_id ascending.

Schema

stores

Column	Type	Description
store_idPK	INT	Unique identifier for the retail store
store_name	VARCHAR(100)	Retail store name
region	VARCHAR(50)	Geographic region containing the store

sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
store_id	INT	Identifier of the store that generated the sale
revenue	NUMERIC(12,2)	Revenue generated by the sale

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