SQL Select and Filtering | Dataford Interview Questions

Implement a simple select statement and add an IN clause and filters to it.

Write a PostgreSQL query against the mortgage_accounts table. Return accounts whose status is either active or delinquent, whose state is either TX or FL, and whose escrow balance is greater than zero.

Output

Return loan_id, borrower_name, state, loan_status, and escrow_balance.
Include only rows meeting all stated conditions.
Order results by loan_id ascending.

Schema

mortgage_accounts

Column	Type	Description
loan_idPK	INT	Unique mortgage loan identifier
borrower_name	VARCHAR(100)	Primary borrower name
state	VARCHAR(2)	Two-letter property state code
loan_status	VARCHAR(30)	Current mortgage loan status
escrow_balance	DECIMAL(12,2)	Current escrow account balance

Your question is SQL Select and Filtering. 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

Implement a simple select statement and add an IN clause and filters to it.

Output

Return loan_id, borrower_name, state, loan_status, and escrow_balance.
Include only rows meeting all stated conditions.
Order results by loan_id ascending.

Schema

mortgage_accounts

Column	Type	Description
loan_idPK	INT	Unique mortgage loan identifier
borrower_name	VARCHAR(100)	Primary borrower name
state	VARCHAR(2)	Two-letter property state code
loan_status	VARCHAR(30)	Current mortgage loan status
escrow_balance	DECIMAL(12,2)	Current escrow account balance

Your question is SQL Select and Filtering. 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.