sql笔试题

面试题1

select f.user_id, follower_id, ml.user_id,music_id, music_name
from follow f
inner join music_likes ml
on f.follower_id = ml.user_id
inner join music m
on ml.music_id=m.id
where f.user_id=1
and music_id not in (select music_id from music_likes where user_id=1)
order by music_id ASC;