Query: ecr_repository_by_region

select
  region as "Region",
  count(*) as "ecr repositories"
from
  aws_ecr_repository
group by
  region
order by
  region;