Which city has the most number of customers?
select t2.city from customers as t1 join addresses as t2 on t1.customer_address_id = t2.address_id group by t2.city order by count ( * ) desc limit 1
Which city has the least number of customers?
select t2.city from customers as t1 join addresses as t2 on t1.customer_address_id = t2.address_id group by t2.city order by count ( * ) limit 1
The city name that appears the most
select t2.city from customers as t1 join addresses as t2 on t1.customer_address_id = t2.address_id where t1.customer_status_code = 'Bad Customer' group by t2.city order by count ( * ) limit 1
What is the country of Ericamouth?
select country from addresses where city = 'Ericamouth'