Your question is SQL Report With Missing Addresses. 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.
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.
FirstName, LastName, City, and State for every row in person.NULL for missing address fields.person_id ascending so the output is deterministic.Use a join that does not accidentally exclude profiles lacking address records.
| 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 |
| 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 |