2023-10-20 17:26 西安欧亚学院 大数据开发工程师
关注
select
mc1.music_name
from(
SELECT
distinct
mc.id,
mc.music_name
FROM follow fw
left join music_likes ml on ml.user_id = fw.follower_id
left join music mc on mc.id = ml.music_id
WHERE fw.user_id = 1
AND ml.music_id NOT IN (SELECT music_id from music_likes where user_id = 1)
order by mc.id
) mc1
order by mc1.id
mc1.music_name
from(
SELECT
distinct
mc.id,
mc.music_name
FROM follow fw
left join music_likes ml on ml.user_id = fw.follower_id
left join music mc on mc.id = ml.music_id
WHERE fw.user_id = 1
AND ml.music_id NOT IN (SELECT music_id from music_likes where user_id = 1)
order by mc.id
) mc1
order by mc1.id
「求助大佬帮看看这道算法题吧！」假设云音乐数据库里面现在有几张如下简化的数据表: 关注follow表,第一列是关注人的id,第二列是被关注人的id,这2列的id组成主键 user_id fol...
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2Fpractice%2F048ed413ac0e4cf4a774b906fc87e0e7
全部评论
相关推荐
美团成长空间 2663人发布 点赞 评论 收藏
分享
查看12道真题和解析