order.sql

select

state_name,
st_area(state_geom) / 2.59e+6 as square_miles

from
`bigquery-public-data.geo_us_boundaries.states`

# we can order by any value in our table, or by a return value from a function
# we don't need to change it to square miles
# since we can just use square meters to order
# desc allows us to order by the area, in descending order

order by st_area(state_geom) desc