Introduction
Practice
5. Exercise 4
Summary

Instruction

Nicely done! On to the next exercise.

Exercise

For each district find the total area in square meters of hotels intersecting the district. Show the name of each district alongside the total hotel area. Sort by the total area in descending order.

Stuck? Here's a hint!

Use SUM with ST_Area as its argument. Also, be sure to use ST_Transform with an SRID of 26910.

Console

Code editor

Result

TableConsole