Query: ibm_compute_instance_vpc

select
  vpc ->> 'name' as "Name",
  vpc ->> 'id' as "ID",
  vpc ->> 'href' as "HREF",
  vpc ->> 'crn' as "CRN"
from
  ibm_is_instance
where
  crn = $1
order by
  vpc ->> 'name';