Query: repository_security_advisory_high_count

select
  'High' as label,
  count(*) as value,
  case
    when count(*) > 0 then 'alert'
    else 'ok'
  end as type
from
  github_my_repository r
  join github_repository_dependabot_alert a on r.name_with_owner = a.repository_full_name
where
  a.state = 'open'
  and a.security_advisory_severity = 'high';