Introduction
Points
Linestrings
Polygons
32. Exercise 2
Summary

Instruction

Let's do one more exercise.

Exercise

Find the average area for each district type in San Francisco. Show the type of district in the first column and the average area in the second column. Your results should be in square meters.

Stuck? Here's a hint!

Use a GROUP BY clause to get the averages for each type of district. Use the right SRID (26910).

Console

Code editor

Result

TableConsole