CREATE TABLE address (city_id VARCHAR2)
CREATE TABLE city (city VARCHAR2, city_id VARCHAR2)

Which city has the most addresses? List the city name, number of addresses, and city id.
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
SELECT "T2"."city", COUNT(*), "T1"."city_id" FROM "address" "T1" JOIN "city" "T2" ON "T1"."city_id" = "T2"."city_id" GROUP BY "T1"."city_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY