Database: address_1
Question: Show all city names and the average distance to all other cities.
SQL:
SELECT T2.city_name ,  avg(distance) FROM Direct_distance AS T1 JOIN City AS T2 ON T1.city1_code  =  T2.city_code GROUP BY T1.city1_code