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
Introduction
Practice
14. Exercise 13
Summary

Instruction

That's right! A few more exercises, and then we're done!

Exercise

How many tram stops can be found within 1000 meters of each hotel in San Francisco? Show the hotel name and the number of trams in the vicinity. Order the results by count in descending order.

Stuck? Here's a hint!

Use a spatial join with ST_DWithin. Remember to use ST_Transform with an SRID of 26910.