lat_lng.sql

select

state_name,
st_x(st_centroid(state_geom)) as lng,
st_y(st_centroid(state_geom)) as lat

# we can use two functions together
# st_centroid returns a geography
# which we can pass to st_x and st_y which return the lat/longs of the point

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