Polygon in Postgres/PostGIS database. It has the spatial reference 4269 which is in degrees.
I know there is a ST_Area() to calculate it. this is my query to select the areas in the SRID units.
select st_area(geom) from counties;
I want to calculate the area in Square Miles and insert a column named Area with the correct Square Mileage for each county
*I am a new to SQL and Postgres