使用两个子查询的结果来计算比率

I have the query below

我有下面的查询

SELECT 'Active Borrowers per Loan Officer' AS PERFORMANCE_RATIOS,
    (
        SELECT count(DISTINCT L.CUSTOMER_ID) / COUNT(DISTINCT L.MIS_ACCT_OFFICER) AS RATIO
        FROM LD_LOANS_AND_DEPOSITS L
        WHERE REPORT_DATE = (
                SELECT MIN(REPORT_DATE)
                FROM LD_LOANS_AND_DEPOSITS
                )
        ) AS RATIO1,
    (
        SELECT count(DISTINCT L.CUSTOMER_ID) / COUNT(DISTINCT L.MIS_ACCT_OFFICER) AS RATIO
        FROM LD_LOANS_AND_DEPOSITS L
        WHERE REPORT_DATE = (
                SELECT MAX(REPORT_DATE)
                FROM LD_LOANS_AND_DEPOSITS
                )
        ) AS RATIO2,
    (
        (
            SELECT count(DISTINCT L.CUSTOMER_ID) / COUNT(DISTINCT L.MIS_ACCT_OFFICER) AS RATIO
            FROM LD_LOANS_AND_DEPOSITS L
            WHERE REPORT_DATE = (
                    SELECT MAX(REPORT_DATE)
                    FROM LD_LOANS_AND_DEPOSITS
                    )
            ) - (
            SELECT count(DISTINCT L.CUSTOMER_ID) / COUNT(DISTINCT L.MIS_ACCT_OFFICER) AS RATIO
            FROM LD_LOANS_AND_DEPOSITS L
            WHERE REPORT_DATE = (
                    SELECT MIN(REPORT_DATE)
                    FROM LD_LOANS_AND_DEPOSITS
                    )
            )
        ) / (
        SELECT count(DISTINCT L.CUSTOMER_ID) / COUNT(DISTINCT L.MIS_ACCT_OFFICER) AS RATIO
        FROM LD_LOANS_AND_DEPOSITS L
        WHERE REPORT_DATE = (
                SELECT MIN(REPORT_DATE)
                FROM LD_LOANS_AND_DEPOSITS
                )
        ) * 100 AS CHANGE,
    (
        SELECT MIN(REPORT_DATE)
        FROM LD_LOANS_AND_DEPOSITS
        ) AS REPORT_DATE1,
    (
        SELECT MAX(REPORT_DATE)
        FROM LD_LOANS_AND_DEPOSITS
        ) AS REPORT_DATE2
SELECT 'Acti