How to find Oracle Fusion Instance Name through SQL

Wondering how to find the name of your Fusion instance ? Here's the query that will retrieve this information -

SELECT

    SUBSTR(

        EXTERNAL_VIRTUAL_HOST,

        1,

        INSTR(EXTERNAL_VIRTUAL_HOST, '.') -1

    ),

    DEPLOYED_DOMAIN_NAME

FROM

    FUSION.ASK_DEPLOYED_DOMAINS