Query: sns_topic_by_account

select
  a.title as "Account",
  count(i.*) as "total"
from
  aws_sns_topic as i,
  aws_account as a
where
  a.account_id = i.account_id
group by
  a.title
order by
count(i.*) desc;