Query: codebuild_project_privileged_mode_status

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