题解 | 下单最多的商品
下单最多的商品
https://www.nowcoder.com/practice/d7c93e3a3d5b4087896539121d32d367
select t.product_id ,count(*) as cnt from product_info t left join user_client_log t1 on t.product_id=t1.product_id where t1.step='order' group by t.product_id limit 1
查看12道真题和解析