Query: wellarchitected_workload_answered_question_count

with question_counts as (
  select
    sum((risk_counts ->> 'UNANSWERED') :: int) as unanswered_questions,
    sum((risk_counts ->> 'HIGH') :: int) + sum((risk_counts ->> 'MEDIUM') :: int) + sum((risk_counts ->> 'NONE') :: int) + sum((risk_counts ->> 'NOT_APPLICABLE') :: int) as answered_questions
  from
    aws_wellarchitected_lens_review as r
  where
    r.workload_id = $1
    and r.lens_arn = any(string_to_array($2, ','))
)
select
  'Answered Questions' as label,
  answered_questions || '/' || unanswered_questions + answered_questions || ' (' || (
    100 * answered_questions / (unanswered_questions + answered_questions)
  ) :: numeric || '%)' as value,
  case
    when unanswered_questions = 0 then 'ok'
    else 'alert'
  end as type
from
  question_counts