题解 | 商品交易(网易校招笔试真题)
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select goods.*,total
from (
select goods_id,
sum(count) as total
from trans
group by goods_id
having sum(count)>20
) total_tb join goods on total_tb.goods_id=goods.id
where weight<50
order by id;
查看15道真题和解析