Introduction
Points
Linestrings
Polygons
31. Exercise 1
Summary

Instruction

Okay, it's time for some additional practice.

Exercise

Find the minimum and maximum perimeters of all hotels in San Francisco. Show the results in meters.

Stuck? Here's a hint!

Use the MIN() and MAX() functions. Remember to use ST_Transform with the right SRID (26910).

Console

Code editor

Result

TableConsole