[Database]Leetcode 175 Combine Two Tables

table:person

<pre>

</pre>

address:

Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:

select firstname,lastname,city,state

from person

left join address

on person.personid=address.personid