题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
http://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
因为只用一个查询时同时使用distinct和order by会报错,所以再套一层子查询
select music_name from
(select distinct ml.music_id,m.music_name
from follow f
left join music_likes ml on f.follower_id=ml.user_id
left join music m on ml.music_id=m.id
where f.user_id=1
and ml.music_id not in
(
select music_id from music_likes where music_likes.user_id=1
)
)a
order by music_id