SQL Report With Missing Addresses | Dataford Interview Questions

PlayStation QA needs a profile coverage report for PlayStation Network accounts. Write a PostgreSQL query that returns every person, whether or not a matching address exists.

Requirements

Return FirstName, LastName, City, and State for every row in person.
Preserve people without an address, showing NULL for missing address fields.
Order the report by person_id ascending so the output is deterministic.

Use a join that does not accidentally exclude profiles lacking address records.

Schema

person

Column	Type	Description
person_idPK	INTEGER	Unique person identifier
first_name	VARCHAR(50)	Person's first name
last_name	VARCHAR(50)	Person's last name

address

Column	Type	Description
address_idPK	INTEGER	Unique address identifier
person_id	INTEGER	Person associated with the address
city	VARCHAR(100)	City in the profile address
state	VARCHAR(100)	State, province, or region

Your question is SQL Report With Missing Addresses. Start with the requirements and the two tables 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