combine_two_tables.sql

'''
Write an SQL query to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead.

Return the result table in any order.

The query result format is in the following example.
'''


select firstName, lastName, city, state from Person left join Address 
on Person.personId = Address.personId