Your question is Second-Highest Client Transaction Amount. Start with the requirements and the two 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.
Write a PostgreSQL query to return the second-highest distinct transaction amount for each client. Include client_id, client_name, and second_highest_amount. Exclude clients that do not have at least two distinct non-NULL transaction amounts.
| Column | Type | Description |
|---|---|---|
| client_id | ||
| client_name | ||
| segment |
| Column | Type | Description |
|---|---|---|
| transaction_id | ||
| client_id | ||
| amount | ||
| transaction_date |
| 1 | Ava Patel | Institutional |
| 4 | Daniel Kim | Institutional |
| 6 | Farah Ali | Retail |
| 101 | 1 | 900.00 | 2024-03-12 |
| 102 | 1 | 500.00 | 2024-02-10 |
| 109 | 4 | 1100.00 | 2024-03-15 |
| 114 | 6 | 450.00 | 2024-02-21 |