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;