目录
0 数据准备
create table follow
(
user_id int,
follower_id int
)row format delimited
fields terminated by '\t';
insert into follow values (1,2);
insert into follow values (1,4);
insert into follow values (1,5);
create table music_likes
(
user_id int,
music_id int
)row format delimited
fields terminated by '\t';
insert into music_likes values (1,20);
insert into music_likes values (1,30);
insert into music_likes values (1,40);
insert into music_likes values (2,10);
insert into music_likes values (2,20);
insert into music_likes values (2,30);
insert into music_likes values (4,10);
insert into music_likes values (4,20);
insert into music_likes values (4,