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;