复制WITH PROD_QUANTITY AS (SELECT PRODUCT_ID,公共 SUM (QUANTITY) AS QUANTITY FROM CUSTOMER_ORDER_ITEM GROUP BY PRODUCT_ID), TOTALS AS (SELECT -1 AS PRODUCT_ID, SUM(QUANTITY) AS TOTAL) SELECT PRODUCT_ID, QUANTITY FROM PROD_QUANTITY UNION SELECT PRODUCT_ID, TOTALS FROM TOTALS ORDER BY 1 DESC 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.