Postgres 9.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table followers (
  user1_id int,
  user2_id int
);

create table likes (
  user_id int,
  song_id int
);
create table songs (
  song_id int,
  name varchar,
  artist varchar
);

insert into followers values ('1', '2');
insert into followers values ('1', '3');
insert into followers values ('1', '4');
insert into followers values ('2', '1');
insert into followers values ('2', '3');
insert into followers values ('2', '4');
insert into followers values ('3', '2');
insert into followers values ('4', '2');

insert into likes values ('1', '1');
insert into likes values ('1', '4');
insert into likes values ('1', '5');
insert into likes values ('2', '2');
insert into likes values ('2', '3');
insert into likes values ('2', '7');
insert into likes values ('2', '9');
insert into likes values ('2', '11');
insert into likes values ('2', '12');
insert into likes values ('3', '13');
insert into likes values ('3', '6');
insert into likes values ('3', '8');
insert into likes values ('3', '3');
insert into likes values ('3', '2');
insert into likes values ('4', '1');
insert into likes values ('4', '8');
insert into likes values ('4', '3');

insert into songs values ('1', 'pipe down', 'drake');
insert into songs values ('2', 'sanctuary', 'joji');
insert into songs values ('3', 'gold digger', 'kanye');
insert into songs values ('4', 'butter', 'bts');
insert into songs values ('5', 'ultimate', 'denzel curry');
insert into songs values ('6', 'daily routine', 'joey badass');
insert into songs values ('7', 'self love', 'mavi');
insert into songs values ('8', 'chanel', 'frank ocean');
insert into songs values ('9', 'spaceship', 'kanye');
insert into songs values ('10', 'tuscan leather', 'drake');
insert into songs values ('11', 'homecoming', 'kanye');
insert into songs values ('12', 'hello', 'adele');
insert into songs values ('13', 'easy on me', 'adele');

INSERT 0 1

user_id	song_id	like_count	name	artist
1	3	3	gold digger	kanye
1	2	2	sanctuary	joji
1	8	2	chanel	frank ocean
1	9	1	spaceship	kanye
1	6	1	daily routine	joey badass
1	13	1	easy on me	adele
1	12	1	hello	adele
1	11	1	homecoming	kanye
1	7	1	self love	mavi
2	8	2	chanel	frank ocean
2	1	2	pipe down	drake
2	13	1	easy on me	adele
2	4	1	butter	bts
2	5	1	ultimate	denzel curry
2	6	1	daily routine	joey badass
3	1	1	pipe down	drake
3	7	1	self love	mavi
3	5	1	ultimate	denzel curry
3	9	1	spaceship	kanye
3	11	1	homecoming	kanye
3	4	1	butter	bts
3	12	1	hello	adele
4	12	1	hello	adele
4	11	1	homecoming	kanye
4	5	1	ultimate	denzel curry
4	2	1	sanctuary	joji
4	7	1	self love	mavi
4	9	1	spaceship	kanye
4	4	1	butter	bts

SELECT 29