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;