Query: codepipeline_pipeline_by_account

select
  a.title as "Account",
  count(c.*) as "pipelines"
from
  aws_codepipeline_pipeline as c,
  aws_account as a
where
  a.account_id = c.account_id
group by
  a.title
order by
  a.title;