The Art of PostgreSQL/

...

/

Challenge: Search for the Nearest Circuits

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
...