- having 作用类似于where,差别是where过滤行,having过滤组
- 使用顺序:where、having、group by、order by、limit
SELECT
*
FROM t_order
WHERE STATUS = 6
GROUP BY user_id
HAVING COUNT(total_amount) > 2
ORDER BY create_time
LIMIT 0,10