Query: wellarchitected_workload_pillar_risk_table

select
  p ->> 'PillarName' as "Pillar Name",
  sum((p -> 'RiskCounts' ->> 'HIGH') :: int) as "High",
  sum((p -> 'RiskCounts' ->> 'MEDIUM') :: int) as "Medium",
  sum((p -> 'RiskCounts' ->> 'NONE') :: int) as "No Improvements",
  sum((p -> 'RiskCounts' ->> 'NOT_APPLICABLE') :: int) as "Not Applicable"
from
  aws_wellarchitected_lens_review as r,
  jsonb_array_elements(r.pillar_review_summaries) as p
where
  r.workload_id = $1
  and r.lens_arn = any(string_to_array($2, ','))
group by
  "Pillar Name"
order by
  "Pillar Name"