题解 | 用户购买次数前三
用户购买次数前三
https://www.nowcoder.com/practice/e359c071d29c4fb7bac6d346f0cfe1d0
select t1.uid ,count(*) as cnt from user_client_log t1 where t1.step = 'order' group by t1.uid order by cnt desc limit 3
用户购买次数前三
https://www.nowcoder.com/practice/e359c071d29c4fb7bac6d346f0cfe1d0
select t1.uid ,count(*) as cnt from user_client_log t1 where t1.step = 'order' group by t1.uid order by cnt desc limit 3
相关推荐