Query: repository_security_advisory_count

select
  'Open Advisories' as label,
  count(*) as value
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 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'
  );