Find all the address ids for the city called Lake Geovannyton.
select address_id from addresses where city = "Lake Geovannyton"
Find all the customers whose address is in this city.
select * 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 where t3.city = "Lake Geovannyton"
How many customers are living there?
select count(*) 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 where t3.city = "Lake Geovannyton"