GEOGRAPHY_AREA
This function measures the square meter area of a given polygon.

Syntax
GEOGRAPHY_AREA ( polygon )
Arguments
polygon: any valid geospatial object or WKT string.
Important
If an argument is a point or line, the area is zero.
Return Type
A double. The measured area, in meters.
Examples
SELECT name, ROUND(geography_area(shape), 0) AS sqm -> FROM neighborhoods ORDER BY 2; +----------------------+---------+ | name | sqm | +----------------------+---------+ | Probability Bay | 584004 | | Axiom Township | 2122520 | | Decentralized Park | 2538930 | | Isle Zero | 2729536 | | Elegant Island | 3037299 | | Little Endian | 3432952 | | Big Endian | 5006800 | ...