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;