Query: vpc_security_group_by_acount

select
  a.title as "Account",
  count(s.*) as "security_groups"
from
  aws_vpc_security_group as s,
  aws_account as a
where
  a.account_id = s.account_id
group by
  a.title
order by
  a.title;