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;