Find distinct cities of addresses of people?
select distinct t1.city from addresses as t1 join people_addresses as t2 on t1.address_id = t2.address_id