Query: sqs_queue_by_dlq_status

select
  redrive_policy_status,
  count(*)
from
  (
    select
      redrive_policy,
      case
        when redrive_policy is not null then 'configured'
        else 'not configured'
      end redrive_policy_status
    from
      aws_sqs_queue
  ) as t
group by
  redrive_policy_status
order by
  redrive_policy_status desc;