AVG平均值
课程：SQL · 编程练习
SQL编程练习 - AVG平均值
练习内容
-- 计算平均年龄\nSELECT AVG(age) AS average_age FROM users;\n\n-- 计算平均订单金额\nSELECT AVG(amount) AS avg_order_amount FROM orders;\n\n-- 按城市计算平均年龄\nSELECT city, AVG(age) AS avg_age\nFROM users\nGROUP BY city;\
课程：SQL · 编程练习
SQL编程练习 - AVG平均值
-- 计算平均年龄\nSELECT AVG(age) AS average_age FROM users;\n\n-- 计算平均订单金额\nSELECT AVG(amount) AS avg_order_amount FROM orders;\n\n-- 按城市计算平均年龄\nSELECT city, AVG(age) AS avg_age\nFROM users\nGROUP BY city;\