Challenge: Search for the Nearest Circuits
Try a hands-on exercise to test your understanding of SQL clauses and available functions in PostgreSQL.
We'll cover the following
Problem statement
Here is a table for circuits. The data in the circuits
table looks like the following:
-[ RECORD 1 ]----------------------------------------------------------
circuitid | 1
circuitref | albert_park
name | Albert Park Grand Prix Circuit
location | Melbourne
country | Australia
lat | -37.8497
lng | 144.968
alt | 10
url | http://en.wikipedia.org/wiki/Melbourne_Grand_Prix_Circuit
Write a query to find the five nearest circuits to Paris, France. You need to retrieve the information present in the following columns:
name
location
country
Here are the values of geographic points that you will need:
Longitude: 2.349014
Latitude: 48.864716
Get hands-on with 1200+ tech skills courses.