On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
5. Exercise 4


Nicely done! On to the next 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.