Query: ibm_compute_instance_data_volume

select
  a -> 'volume' ->> 'name' as "Name",
  a -> 'volume' ->> 'id'  as "ID",
  a ->> 'name' as "Attachment Name",
  a ->> 'id'  as "Attachment ID"
from
  ibm_is_instance,
  jsonb_array_elements(volume_attachments) as a
where
  a ->> 'id' <> boot_volume_attachment ->> 'id'
  and crn = $1
order by 
  a -> 'volume' ->> 'name';