Query: ec2_instance_ebs_optimized_status

with instances as (
  select
    case
      when ebs_optimized then 'enabled'
      else 'disabled'
    end as visibility
  from
    aws_ec2_instance
)
select
  visibility,
  count(*)
from
  instances
group by
  visibility