Query: iam_roles_by_path

select
  case when path = '/' then '/*'
  else '/' || (split_part(path, '/', 2)) || '/*' end as path_status,
  count(*) as "total"
from
  aws_iam_role
group by
  path_status
order by
  total desc;