SELECT * FROM (

    SELECT
        1,
        'BANK',
        BANK.BANK_NAME,
        LT.LOAN_TYPE_DESC,
        BAL.OUTSTANDING_PRINCIPAL,
        BAL.TOTAL_OUTSTANDING_BALANCE

    FROM BANK_TBL BANK

    JOIN BANK_LOAN_TYPE BLT
    ON BLT.REF_BANK_ID = BANK.BANK_ID

    JOIN LOAN_TYPE LT
    ON BLT.REF_LOAN_TYPE_ID = LT.LOAN_TYPE_ID

    JOIN BALANCE_TBL BAL
    ON BAL.BALANCE_ID = BLT.REF_BALANCE_ID

    UNION

    SELECT
        COUNT(*),
        'LOAN',
        BANK.BANK_NAME,
        LOAN.LOAN_TYPE,
        SUM(BAL.OUTSTANDING_PRINCIPAL),
        SUM(BAL.TOTAL_OUTSTANDING_BALANCE)

    FROM LOAN_TBL LOAN

    JOIN BANK_TBL BANK
    ON BANK.BANK_ID = LOAN.REF_BANK_ID

    JOIN BALANCE_TBL BAL
    ON BAL.BALANCE_ID = LOAN.REF_BALANCE_ID

    GROUP BY
        BANK.BANK_NAME,
        LOAN.LOAN_TYPE

    UNION

    SELECT
        COUNT(*),
        'PN',
        BANK.BANK_NAME,
        LOAN.LOAN_TYPE,
        SUM(BAL.OUTSTANDING_PRINCIPAL),
        SUM(BAL.TOTAL_OUTSTANDING_BALANCE)

    FROM PN_TBL PN

    JOIN LOAN_TBL LOAN
    ON LOAN.LOAN_ID = PN.REF_LOAN_ID

    JOIN BANK_TBL BANK
    ON BANK.BANK_ID = LOAN.REF_BANK_ID

    JOIN BALANCE_TBL BAL
    ON BAL.BALANCE_ID = LOAN.REF_BALANCE_ID

    GROUP BY
        BANK.BANK_NAME,
        LOAN.LOAN_TYPE

) ORDER BY BANK_NAME, LOAN_TYPE_DESC, 2