Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Functions returning geometries
18. Exercise 3


Perfect! How about this one?


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.