Introduction
Functions returning geometries
Collections
Summary
18. Exercise 3

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.

Console

Code editor

Result

TableConsole