Window Function for Second-Highest | Dataford Interview Questions

Write a SQL query using window functions to find the second-highest mortgage application volume by region.

Use the regions and mortgage_applications tables. Include regions with no applications when calculating volumes, and return every region tied at the second-highest volume.

Output

One row per qualifying region with region_name and application_volume.
Include only regions at the second-highest volume rank.
Order results alphabetically by region_name.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique identifier for a geographic region
region_name	VARCHAR(100)	Name of the geographic region

mortgage_applications

Column	Type	Description
application_idPK	INT	Unique identifier for a mortgage application
region_id	INT	Region associated with the application
application_date	DATE	Date the mortgage application was submitted
application_status	VARCHAR(30)	Current processing status of the application

Your question is Window Function for Second-Highest. 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