Challenge: Explore City Distances and Locations

Use the geography_examples table to answer the following questions about city coordinates and distances.

1. Create a geography point for each row using the latitude and longitude columns;
2. Calculate the distance (in kilometres) from London to every other city in the dataset;
3. Identify cities that are within 1000 kilometres of London.

Your query should return these columns:

For step 1:

• id;
• city;
• latitude;
• longitude;
• geography_point.

For step 2:

• city;
• distance_from_london_km.

For step 3:

• city;
• distance_from_london_km.

(Only include cities less than 1000 km away).