牛客862645826号

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | #商品交易(网易校招笔试真题)#

select g.id, g.name, g.weight, a.cnt from goods g left join (select t.goods_id,sum(t.count) as cnt from trans t group by t.goods_id)a on a.goods_id=g....

Mysql

2021-12-25

0 344

题解 | #网易云音乐推荐(网易校招笔试真题)#

select T.music_name from (select /f.user_id, f.follower_id,/ distinct m1.music_id, m2.music_name from follow f left join music_likes m1 on f.follower_...

Mysql

2021-12-25

0 319