On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Relationships Between Geometries
11. Additional exercise - ST_Intersects
ST_Distance and ST_Dwithin
Spatial joins practice


Well done! It's time for some additional exercises.


How many hotels that intersect with Downtown have an average price for a double room below 100?

Stuck? Here's a hint!

Use COUNT(*) in the SELECT clause. Join sf_planning_districts with sf_hotels and introduce two conditions in the WHERE clause.