Query: ebs_volume_by_state

select
  state,
  count(state)
from
  aws_ebs_volume
group by
  state;