Query: ecs_instance_by_io_optimized

with instances as (
  select
    case
      when io_optimized then 'enabled'
      else 'disabled'
    end as state
  from
    alicloud_ecs_instance
)
select
  state,
  count(*)
from
  instances
group by
  state;