Top 10 Customers by Loan Amount | Dataford Interview Questions

LendingClub's personal-loan analytics team wants to identify borrowers associated with the largest total amount of issued loans. Write a PostgreSQL query that aggregates loan amounts by borrower and returns the top 10 borrowers.

Requirements

Include only loans where loan_status = 'Issued'.
Calculate each borrower's total issued loan amount.
Return the borrower's ID, name, and total amount, ordered from highest to lowest. Break ties with the smaller customer_id and return only 10 rows.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique borrower identifier
customer_name	VARCHAR(100)	Borrower's name
state	VARCHAR(2)	Borrower's state abbreviation

loans

Column	Type	Description
loan_idPK	INT	Unique loan identifier
customer_id	INT	Borrower associated with the loan
loan_amount	DECIMAL(12,2)	Original loan amount
loan_status	VARCHAR(20)	Current loan status

Your question is Top 10 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.

Problem