What are the city name, id, and number of addresses corresponding to the city with the most addressed?
SELECT T2.city ,  count(*) ,  T1.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
city with the most addresses refers to MAX(COUNT(addresses)); city name and city id refer to attributes in the city entity; number of addresses corresponding to a city refers to COUNT(addresses) GROUP BY city_id;