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.
| city | state | lastname | firstname |
|---|---|---|---|
| New York | NY | Smith | Alice |
| Los Angeles | CA | Brown | Carol |
| NULL | NULL | Jones | Bob |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in