Your question is SQL Multi-Concept Query. Start with the requirements and the four tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Applied Data Finance needs a servicing report for loans originated through its lending platform. Write a PostgreSQL query that identifies loans with the second-highest distinct principal amount within each product and combines borrower, product, and payment information.
YYYY-MM-DD using PostgreSQL date formatting.0 and NULL for latest payment fields.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique borrower identifier |
| customer_name | VARCHAR(100) | Borrower full name |
| VARCHAR(255) | Borrower email address |
| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique lending product identifier |
| product_name | VARCHAR(100) | Name of the Applied Data Finance lending product |
| Column | Type | Description |
|---|---|---|
| loan_idPK | INT | Unique loan identifier |
| customer_id | INT | References customers.customer_id |
| product_id | INT | References products.product_id |
| principal_amount | NUMERIC(12,2) | Approved loan principal |
| origination_date | DATE | Date the loan was originated |
| Column | Type | Description |
|---|---|---|
| payment_idPK | INT | Unique payment identifier |
| loan_id | INT | References loans.loan_id |
| payment_date | DATE | Date the payment was received |
| payment_amount | NUMERIC(12,2) | Payment amount received |