Introduction
ST_Equals
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
Summary
26. Exercise 3

Instruction

Excellent! How about this one?

Exercise

Mark's friends have arrived in San Francisco! They want to spend as little as possible on hotels, yet they want to have quick access to good restaurants.

Show the name, rating, type of food served for all restaurants with rating above 4.0 that are within 2000 meters from the hotels in San Francisco that cost less than $52 a night. Also, show the name of the hotel.

Console

Code editor

Result

TableConsole