Query: compute_instance_deletion_protection_status

with instances as (
  select
    case
      when deletion_protection then 'enabled'
      else 'disabled'
    end as deletion_protection_status
  from
    gcp_compute_instance
)
select
  deletion_protection_status,
  count(*)
from
  instances
group by
  deletion_protection_status;