Query: repository_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_repository r
  join github_repository_dependabot_alert a on r.name_with_owner = a.repository_full_name
where
  a.state = 'open'
  and r.name_with_owner like 'turbot/steampipe-plugin%'
  and a.security_advisory_severity = 'medium'
  and r.name_with_owner not in ('turbot/steampipe-plugin-papertrail', 'turbot/steampipe-plugin-wordpress', 'turbot/steampipe-plugin-html', 'turbot/steampipe-plugin-chaos', 'turbot/steampipe-plugin-chaosratelimit', 'turbot/steampipe-plugin-chaosdynamic', 'turbot/steampipe-plugin-pokemon', 'turbot/steampipe-plugin-gitlab');