Query: kms_key_by_location

select
  location,
  count(k.*) as total
from
  gcp_kms_key as k
group by
  location;