Joining Two Tables

Combine the Person and Address tables. For every person return their first name, last name, city and state. If there is no address, return NULL.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

firstname	lastname	city	state
Alice	Smith	New York	NY
Carol	Brown	Los Angeles	CA
Bob	Jones	NULL	NULL

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid