SQL 嵌套查询

Question

查询出每个user_id出现的次数：
SELECT user_id, COUNT(user_id) AS cc FROM USER GROUP BY user_id
我现在想要做的是查询出 cc>1 的用户情况,不知道怎么写

Answer 1

my god...

    SELECT user_id, COUNT(*) AS cc FROM USER GROUP BY user_id having cc>1;