Yes, and also the cities.
select address_content,city from addresses
Hmm, I want to know the cities with customers living in.
select city from addresses where city in ( select distinct t3.city from customers as t1 join customer_addresses as t2 on t1.customer_id = t2.customer_id join addresses as t3 on t2.address_id = t3.address_id )
Hmm, please list the cities that no customer is living in.
select city from addresses where city not in ( select distinct t3.city from customers as t1 join customer_addresses as t2 on t1.customer_id = t2.customer_id join addresses as t3 on t2.address_id = t3.address_id )