Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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'.