Query: repo_should_have_two_admins

with repo_admins as (
  select
    name_with_owner,
    url,
    count(user_login) as admins
  from
    github_my_repository r
    join github_repository_collaborator c on r.name_with_owner = c.repository_full_name
    and c.permission = 'ADMIN'
  group by
    name_with_owner,
    url
)
select
  url as resource,
  case
    when admins >= 2 then 'ok'
    else 'alarm'
  end as status,
  name_with_owner || case
    when admins >= 2 then ' has ' || admins :: text || ' administrators.'
    else ' has only ' || admins :: text || ' administrators.'
  end as reason,
  name_with_owner
from
  repo_admins;