Instruction
Perfect! How about this one?
Exercise
This time, the San Francisco City Council has decided that each hotel in the Downtown district must erect a fence around its premises for increased security. The fences must be placed at a distance of 3 meters from the hotel borders. For each hotel (sf_hotels table) fully contained within the Downtown district (sf_planning_districts table), show its name, the length (in meters) of the required fence, and the total cost of building the fence (with a price of 10 USD per 1 meter of fence). Show the results in descending order of cost.
Stuck? Here's a hint!
You may have to use ST_Perimeter function.



