Query: sqs_queue_by_type

select
  case
    when fifo_queue then 'FIFO'
    else 'Standard'
  end as queue_type,
  count(i.*) as total
from
  aws_sqs_queue as i
group by
  fifo_queue;