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