Query: vcn_subnets_for_filestorage_file_system

with file_system_export_ids as (
  select
    jsonb_array_elements(exports) ->> 'exportSetId' as export_set_id
  from
    oci_file_storage_file_system
  where
    id = $1
)
select
  subnet_id
from
  file_system_export_ids as e,
  oci_file_storage_mount_target as m
where
  e.export_set_id = m.export_set_id;