题目地址

with 
-- 被关注人喜欢
u_f_m as (
select f.user_id,follower_id,music_id
from follow f join music_likes ml on f.follower_id=ml.user_id
where f.user_id = 1),
-- 关注人喜欢
u_m as (
select f.user_id,music_id
from follow f join music_likes ml on f.user_id = ml.user_id
where f.user_id = 1)
select music_name from 
(select distinct music_name,id
from u_f_m left join u_m on u_f_m.user_id=u_m.user_id and u_f_m.music_id = u_m.music_id
left join music on u_f_m.music_id = music.id
where u_m.music_id is null
order by id) a