Query: activedirectory_group_by_type

select
  case when security_enabled then 'Security' else 'Microsoft 365' end as type,
  count(*) as "Groups"
from
  azuread_group
group by
  type
order by
  type;