Your question is SQL Inner Join for Matches. Start with the requirements and the one table 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.
Freddie Mac analysts review loan performance records to identify loans that are currently active. The interview environment uses a single performance table for this introductory filtering task.
Write a PostgreSQL query that returns only records where the loan status is Current.
loan_id, loan_status, and servicer_name.loan_status = 'Current' and order the results by loan_id in ascending order.| Column | Type | Description |
|---|---|---|
| loan_idPK | INTEGER | Unique Freddie Mac loan identifier |
| loan_status | VARCHAR(20) | Current performance status |
| servicer_name | VARCHAR(100) | Name of the servicing organization |
| monthly_payment | NUMERIC(10,2) | Scheduled monthly payment |