sql题参考答案 SELECT region AS 地区, department AS 部门, product_line AS 产品线, SUM(amount) AS 总金额 FROM sales GROUP BY CUBE(region, department, product_line) -- 自动生成小计和总计 ORDER BY 地区, 部门, 产品线;