order_perimiter.sql

select

state_name,
st_perimiter(state_geom) * 1609 as border_miles

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

order by st_perimiter(state_geom) desc