Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Introduction
Points
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).