Query: groups_admin_created_only

with group_creation_stats as (
  select
    count(*) as total_groups,
    count(*) filter (where admin_created = true) as admin_created_groups,
    count(*) filter (where admin_created = false) as user_created_groups
  from
    googledirectory_group
)
select
  'organization' as resource,
  case
    when user_created_groups = 0 then 'ok'
    else 'alarm'
  end as status,
  case
    when user_created_groups = 0 then 'All ' || total_groups || ' groups were created by administrators.'
    else 'Found ' || user_created_groups || ' groups created by users out of ' || total_groups || ' total groups.'
  end as reason
from
  group_creation_stats;