SQL Rank Customers by Loan Amount | Dataford Interview Questions

Write a SQL query using window functions to rank LendingClub customers by total loan amount within each state and return the top 3 per state.

Use the provided LendingClub customer and loan data. Include customers with at least one loan and exclude loans that do not match a customer.

Output

One row per qualifying customer, with state, customer_id, customer_name, total_loan_amount, and customer_rank
Return the top three customers in each state, ordered by total loan amount descending and customer ID ascending to break ties
Sort the final result by state, then customer_rank, then customer_id

lendingclub_customers

Column	Type	Description
customer_idPK	INT	Unique LendingClub customer identifier
customer_name	VARCHAR(100)	Customer's full name
state	CHAR(2)	Two-letter US state abbreviation

lendingclub_loans

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

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