-- 计算平均年龄 SELECT AVG(age) AS average_age FROM users; -- 计算平均订单金额 SELECT AVG(amount) AS avg_order_amount FROM orders; -- 按城市计算平均年龄 SELECT city, AVG(age) AS avg_age FROM users GROUP BY city;