Ranking Customers by Loan Amount | Dataford Interview Questions

Write a query using window functions to rank customers based on their total loan amounts within each region for Lendbuzz.

Use the customers and loans tables. Include customers with at least one loan and a non-null region.

Output

One row per included customer, with region, customer_name, total_loan_amount, and regional_rank.
Rank customers from highest to lowest total loan amount within each region. Ties share the same rank.
Order by region, regional_rank, then customer_id.

customers

Column	Type	Description
customer_idPK	INT	Unique Lendbuzz customer identifier
customer_name	VARCHAR(100)	Customer's full name
region	VARCHAR(50)	Customer's geographic region

loans

Column	Type	Description
loan_idPK	INT	Unique loan identifier
customer_id	INT	Customer associated with the loan
loan_amount	DECIMAL(12,2)	Principal amount of the loan

Your question is Ranking Customers by Loan Amount. 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.