如何将Order BY放在SQL UNION中,以便TOTALS始终显示为最后一行？

SELECT * FROM (
    SELECT 'A' AS type, SUM(value) AS total
    FROM table1
    GROUP BY type
    UNION
    SELECT 'B' AS type, SUM(value) AS total
    FROM table2
    GROUP BY type
    UNION
    SELECT 'TOTALS' AS type, SUM(value) AS total
    FROM (
        SELECT 'A' AS type, value FROM table1
        UNION
        SELECT 'B' AS type, value FROM table2
    ) AS subquery
) AS result
ORDER BY
    CASE
        WHEN type = 'TOTALS' THEN 1
        ELSE 0
    END DESC,
    type ASC;