Query: wellarchitected_workload_medium_issue_count

with workloads_medium_issue_count as (
  select
    coalesce((risk_counts ->> 'MEDIUM') :: int, 0) as risk_count_medium
  from
    aws_wellarchitected_workload
)
select
  sum(risk_count_medium) as value,
  'Total Medium Risks' as label,
  case
    sum(risk_count_medium)
    when 0 then 'ok'
    else 'alert'
  end as type
from
  workloads_medium_issue_count;