SELECT *, SUM(population) FROM (
    SELECT * FROM (
        SELECT * FROM zip_codes
              ORDER BY zip_code, LENGTH(city) DESC
        ) as cities1
        GROUP BY zip_code
    ) as cities
GROUP BY city