Database: address_1
Question: For each city, what is the the city code and sum of distances from each?
SQL:
SELECT city1_code ,  sum(distance) FROM Direct_distance GROUP BY city1_code