Query: codebuild_project_badge_status

select
  badge_status,
  count(*)
from
  (
    select
      badge ->> 'BadgeEnabled',
      case
        when badge ->> 'BadgeEnabled' = 'true' then 'enabled'
        else 'disabled'
      end badge_status
    from
      aws_codebuild_project
  ) as t
group by
  badge_status
order by
  badge_status desc;