The calculation we performed with the geometry type was unacceptable and very inaccurate. This proves that for great distances or large areas on the Earth, we should perform calculations with the geography type, not geometry.
Unfortunately, there aren't many functions that support the geography type. Among the functions we got to know in this course, only the following functions support geography columns:
Their usage is exactly the same as in the case of geometry columns. Here's a simple example:
The query above finds the perimeter of each USA state.