Query to Find Fusion SaaS Instance url from a Table

SELECT
        external_virtual_host,
        SUBSTR (external_virtual_host, 1,instr(external_virtual_host,'.') -1)
FROM
        fusion.ask_deployed_domains add
WHERE
        add.deployed_domain_name='FADomain'