题解 | 下单最多的商品
下单最多的商品
https://www.nowcoder.com/practice/d7c93e3a3d5b4087896539121d32d367
select t1.product_id, pdiff as cnt from( select product_id, pdiff, dense_rank()over(order by pdiff desc,product_id asc) as py from( select product_id, count(trace_id) as pdiff from user_client_log where step="order" group by product_id ) as t ) as t1 where t1.py=1
，这还是稳定一个月2.5w的前提，草了
投递BOSS直聘等公司7个岗位