Query: cloudtrail_trail_per_account

select
  account_id,
  case when is_multi_region_trail then 'Multi-Regional Trails' else 'Regional Trails' end as status,
  count(*) as trails
from
  aws_cloudtrail_trail
where
  region = home_region
group by 
  account_id, 
  status;