题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
with t as(
select
distinct t.goods_id id,
name,
weight,
sum(count) over(partition by name) total
from goods g
right join trans t on g.id=t.goods_id
)
select *
from t
where total>20 and weight <50
order by id
，再说不用上高数吗？