Query: wellarchitected_workload_lens_risk_table

select
  r.lens_name as "Lens Name",
  (r.risk_counts ->> 'HIGH') :: int as "High",
  (r.risk_counts ->> 'MEDIUM') :: int as "Medium",
  (r.risk_counts ->> 'NONE') :: int as "No Improvements",
  (r.risk_counts ->> 'NOT_APPLICABLE') :: int as "Not Applicable"
from
  aws_wellarchitected_lens_review as r
where
  r.workload_id = $1
  and r.lens_arn = any(string_to_array($2, ','))
group by
  r.lens_name,
  r.risk_counts
order by
  r.lens_name