Posted in Web poweroutage.report April 9, 2020 SELECT c.*, SUM(z.population) as population FROM cities AS c LEFT JOIN zip_codes AS z ON z.name = c.name AND z.state = c.state WHERE 1 AND c.“ = ” GROUP BY ORDER BY ; https://poweroutage.report/michigan