Query: organization_security_advisory_medium_count

select
  'Medium' as label,
  count(*) as value,
  case
    when count(*) > 0 then 'alert'
    else 'ok'
  end as type
from
  github_my_organization o
  join github_organization_dependabot_alert a on o.login = a.organization
where
  a.state = 'open'
  and a.security_advisory_severity = 'medium';