题解 | 下单最多的商品
下单最多的商品
https://www.nowcoder.com/practice/d7c93e3a3d5b4087896539121d32d367
select
product_id
,count(*) as cnt
from
(
select
t1.product_id
,t1.trace_id
from user_client_log t1
left join product_info t2
on t1.product_id = t2.product_id
group by t1.trace_id,t1.product_id
) t3
group by product_id
order by product_id
limit 1