Query: wellarchitected_workload_with_medium_issue_count

with workloads_with_medium_issues as (
  select
    workload_id
  from
    aws_wellarchitected_workload
  where
    coalesce((risk_counts ->> 'MEDIUM') :: int, 0) > 0
)
select
  count(*) as value,
  'Workloads with Medium Risks' as label,
  case
    count(*)
    when 0 then 'ok'
    else 'alert'
  end as type
from
  workloads_with_medium_issues;