题解 | 用户购买次数前三
用户购买次数前三
https://www.nowcoder.com/practice/e359c071d29c4fb7bac6d346f0cfe1d0
SELECT uid, COUNT(step) AS cnt FROM user_client_log WHERE step = 'order' GROUP BY uid ORDER BY cnt DESC, uid LIMIT 3;
用户购买次数前三
https://www.nowcoder.com/practice/e359c071d29c4fb7bac6d346f0cfe1d0
SELECT uid, COUNT(step) AS cnt FROM user_client_log WHERE step = 'order' GROUP BY uid ORDER BY cnt DESC, uid LIMIT 3;
相关推荐