Introduction
Practice
8. Exercise 7
Summary

Instruction

Well done! More exercises coming your way.

Exercise

What is the distance in meters between 'Nourish Hotel' and the nearest ATM?

Stuck? Here's a hint!

You will have to use the following functions: MIN, ST_Distance and ST_Transform with an SRID of 26910. In the ON clause of your join, you can simply write: ON sf_hotels.name = 'Nourish Hotel'.

Console

Code editor

Result

TableConsole