[MySQL] NetApp OCI DWH: From Datastore Name(s) get Volume and Storage

SELECT
    ds.name AS 'DataStore Name',
    v.name AS 'Volume Name',
    s.name AS 'Storage Name'
FROM dwh_inventory.hv_data_store AS ds
JOIN dwh_inventory.hv_data_store_to_volume AS ds2v ON ds2v.dataStoreId = ds.id
JOIN dwh_inventory.storage AS s ON s.id = ds2v.storageId
JOIN dwh_inventory.volume AS v ON v.id = ds2v.volumeId
WHERE ds.name IN(
'datastore1',
'datastore2'
);