Query: ecr_repository_tag_immutability_status

select
  tag_mutability_status,
  count(*)
from
  (
    select
      image_tag_mutability = 'IMMUTABLE',
      case
        when image_tag_mutability = 'IMMUTABLE' then 'enabled'
        else 'disabled'
      end tag_mutability_status
    from
      aws_ecr_repository
  ) as t
group by
  tag_mutability_status
order by
  tag_mutability_status desc;