HAVING筛选
课程：SQL · 编程练习
SQL编程练习 - HAVING筛选
练习内容
-- 查询订单数大于5的用户\nSELECT user_id, COUNT(*) AS order_count\nFROM orders\nGROUP BY user_id\nHAVING COUNT(*) > 5;\n\n-- 查询平均订单金额大于1000的用户\nSELECT user_id, AVG(amount) AS avg_amount\nFROM orders\nGROUP BY u
课程：SQL · 编程练习
SQL编程练习 - HAVING筛选
-- 查询订单数大于5的用户\nSELECT user_id, COUNT(*) AS order_count\nFROM orders\nGROUP BY user_id\nHAVING COUNT(*) > 5;\n\n-- 查询平均订单金额大于1000的用户\nSELECT user_id, AVG(amount) AS avg_amount\nFROM orders\nGROUP BY u