MAX和MIN
课程：SQL · 编程练习
SQL编程练习 - MAX和MIN
练习内容
-- 查询最高和最低年龄\nSELECT MAX(age) AS max_age, MIN(age) AS min_age\nFROM users;\n\n-- 查询最大订单金额\nSELECT MAX(amount) AS max_order FROM orders;\n\n-- 每个分类的最高和最低价格\nSELECT category, MAX(price) AS max_price, MI
课程：SQL · 编程练习
SQL编程练习 - MAX和MIN
-- 查询最高和最低年龄\nSELECT MAX(age) AS max_age, MIN(age) AS min_age\nFROM users;\n\n-- 查询最大订单金额\nSELECT MAX(amount) AS max_order FROM orders;\n\n-- 每个分类的最高和最低价格\nSELECT category, MAX(price) AS max_price, MI