Write and run a SQL query to determine which airport in the fly.airports table is closest to the geographical (not magnetic) North Pole, using the following calculation for the distance in kilometers, using the latitude (lat) column: distance = 6371 * 2 * asin(least(1, sin(radians(90 – lat) / 2)))
(Note: The least function chooses the minimum value among two or more scalar values—similar to the MIN function, but MIN works on values in a column.)
Which airport is closest to the geographical North Pole?
- Aberdeen Regional Airport
- Cowra Airport
- Wainwright Airport
- Wiley Post Will Rogers Memorial Airport
- Zephyrhills Municipal Airport