Query: wellarchitected_workload_risk_count_table

select
  workload_name as "Name",
  coalesce((risk_counts ->> 'HIGH') :: int, 0) as "High",
  coalesce((risk_counts ->> 'MEDIUM') :: int, 0) as "Medium",
  coalesce((risk_counts ->> 'NONE') :: int, 0) as "No Improvements",
  coalesce((risk_counts ->> 'NOT_APPLICABLE') :: int, 0) as "N/A",
  coalesce((risk_counts ->> 'UNANSWERED') :: int, 0) as "Unanswered"
from
  aws_wellarchitected_workload
order by
  "High" desc,
  "Medium" desc