Query: wellarchitected_workload_high_issue_count

with workloads_high_issue_count as (
  select
    coalesce((risk_counts ->> 'HIGH') :: int, 0) as risk_count_high
  from
    aws_wellarchitected_workload
)
select
  sum(risk_count_high) as value,
  'Total High Risks' as label,
  case
    sum(risk_count_high)
    when 0 then 'ok'
    else 'alert'
  end as type
from
  workloads_high_issue_count;