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.

Console

Code editor

Result

TableConsole