SQL Inner Join for Matches | Dataford Interview Questions

Business Context

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.

Task

Write a PostgreSQL query that returns only records where the loan status is Current.

Requirements

Return loan_id, loan_status, and servicer_name.
Include only rows with loan_status = 'Current' and order the results by loan_id in ascending order.

Schema

loan_performance

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

Your question is SQL Inner Join for Matches. Start with the requirements and the one table 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