-- 计算订单总金额 SELECT SUM(amount) AS total_amount FROM orders; -- 计算每个用户的订单总额 SELECT user_id, SUM(amount) AS total FROM orders GROUP BY user_id; -- 计算已完成订单的总金额 SELECT SUM(amount) AS completed_total FROM