Query: group_access_request_count

select
  'Active Requests' as label,
  count(r.*) as value,
  case
    when count(r.*) > 0 then 'alert'
    else 'ok'
  end as type
from
  gitlab_group g
  join gitlab_group_access_request r on g.id = r.group_id
where
  r.state = 'active';