Query: codebuild_project_by_source_type

select
  source -> 'Type' as "Source Type",
  count(*) as "projects"
from
  aws_codebuild_project
group by
  source -> 'Type'
order by
  source -> 'Type';