Top 5 Loans by Region | Dataford Interview Questions

Write a query to find the top 5 loans by balance within each geographical region.

Use the loans table. Exclude rows with a missing region or balance. Ties should be resolved by the smallest loan_id.

Output

One row per selected loan, with geographical_region, loan_id, and balance.
Include no more than five loans per region.
Order by geographical_region, then balance descending, then loan_id ascending.

loans

Column	Type	Description
loan_idPK	INT	Unique loan identifier
geographical_region	VARCHAR(100)	Geographical region associated with the loan
balance	DECIMAL(14,2)	Outstanding loan balance

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the one table are in the Question tab.

Write a query to find the top 5 loans by balance within each geographical region.

Use the loans table. Exclude rows with a missing region or balance. Ties should be resolved by the smallest loan_id.

One row per selected loan, with geographical_region, loan_id, and balance.
Include no more than five loans per region.
Order by geographical_region, then balance descending, then loan_id ascending.

loans

Column	Type	Description
loan_idPK	INT	Unique loan identifier
geographical_region	VARCHAR(100)	Geographical region associated with the loan
balance	DECIMAL(14,2)	Outstanding loan balance

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the one table are in the Question tab.