子查询
课程：SQL · 编程练习
SQL编程练习 - 子查询
练习内容
-- 查询订单金额大于平均值的订单\nSELECT order_id, user_id, amount, created_at\nFROM orders\nWHERE amount > (SELECT AVG(amount) FROM orders);\n\n-- 查询购买过特定产品的用户\nSELECT * FROM users\nWHERE id IN (\n SELECT DISTIN
课程：SQL · 编程练习
SQL编程练习 - 子查询
-- 查询订单金额大于平均值的订单\nSELECT order_id, user_id, amount, created_at\nFROM orders\nWHERE amount > (SELECT AVG(amount) FROM orders);\n\n-- 查询购买过特定产品的用户\nSELECT * FROM users\nWHERE id IN (\n SELECT DISTIN