Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
ST_Equals
Relationships Between Geometries
11. Additional exercise - ST_Intersects
ST_Distance and ST_Dwithin
Spatial joins practice
Summary

Instruction

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

Exercise

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.