LATITUDE() — Returns the latitude of a GEOGRAPHY_POINT value.
The LATITUDE() function returns the latitude, as a floating point value, from a GEOGRAPHY_POINT expression.
The following example returns all ships that are located in the northern hemisphere by examining the latitude of their
SELECT ship.number, ship.country FROM ship
WHERE LATITUDE(ship.location) > 0;