题目链接：
解析：
本题直接考查表的联结，由于题目要求regardless if there is an address for each of those people，所以我们应该使用LEFT JOIN ... ON结构，关于表的联结内容，可以参考：
题解：
# Write your MySQL query statement below
SELECT Person.FirstName, Person.LastName, Address.City, Address.State FROM Person LEFT JOIN Address
ON Person.PersonId = Address.PersonId;