Database: address_1
Question: Show all city codes and the total distance to all other cities.
SQL:
SELECT city1_code ,  sum(distance) FROM Direct_distance GROUP BY city1_code