What is the name of the city with the most addresses?
select t2.city from address as t1 join city as t2 on t1.city_id = t2.city_id group by t1.city_id order by count ( * ) desc limit 1
How many addresses does it have?
select count ( * ) from address as t1 join city as t2 on t1.city_id = t2.city_id group by t1.city_id order by count ( * ) desc limit 1
What is its city id?
select t2.city_id from address as t1 join city as t2 on t1.city_id = t2.city_id group by t1.city_id order by count ( * ) desc limit 1
Can you list the all addresses that have the letter S in them?
select address from address where address like "%s%"