Query: ecr_repository_tagging_status

select
  tag_status,
  count(*)
from (
  select tags = '{}' or tags is null,
    case when tags = '{}' or tags is null then
      'disabled'
    else
      'enabled'
    end tag_status
  from
    aws_ecr_repository) as t
group by
  tag_status
order by
  tag_status desc;