Query: codepipeline_pipeline_by_region

select
  region as "Region",
  count(*) as "pipelines"
from
  aws_codepipeline_pipeline
group by
  region
order by
  region;