Query: ebs_volume_by_type

select
  volume_type as "Type",
  count(*) as "volumes"
from
  aws_ebs_volume
group by
  volume_type
order by
  volume_type;