Query: sns_topic_by_region

select
  region,
  count(i.*) as total
from
  aws_sns_topic as i
group by
  region;