MySQL 8.0

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

CREATE TABLE  songs (
 id int,
 name varchar(20),
 url varchar(20),
 view_count int,
 createdAt datetime,
 updatedAt datetime );

INSERT INTO songs VALUES
(1,'Song A','song-a',154,'2021-12-11 15:34:21','2021-12-11 15:34:21'),
(2,'Song B','song-b',54,'2021-12-13 12:23:12','2021-12-13 12:23:12'),
(3,'Song C','song-c',123,'2021-12-13 13:12:56','2021-12-13 13:12:56'),
(4,'Song D','song-d',15,'2021-12-13 14:01:15','2021-12-13 14:01:15'),
(5,'Song E','song-e',26,'2021-12-14 12:12:03','2021-12-14 12:12:03'),
(6,'Song F','song-f',165,'2021-12-14 13:54:23','2021-12-14 13:54:23'),
(7,'Song G','song-g',121,'2021-12-14 13:54:23','2021-12-14 13:54:23'),
(8,'Song H','song-h',135,'2021-12-14 13:54:23','2021-12-14 13:54:23'),
(9,'Song I','song-i',25,'2021-12-14 13:54:23','2021-12-14 13:54:23'),
(10,'Song J','song-j',15,'2021-12-14 13:54:23','2021-12-14 13:54:23'),
(11,'Song K','song-k',26,'2021-12-14 13:54:23','2021-12-14 13:54:23'),
(12,'Song L','song-l',5,'2021-12-14 13:54:23','2021-12-14 13:54:23');

CREATE TABLE  artists (
 id int,
 name varchar(20),
 url varchar(20),
 createdAt datetime,
 updatedAt datetime );

INSERT INTO artists VALUES
(1,'Artist A','artist-a','2021-12-11 15:34:21','2021-12-11 15:34:21'),
(2,'Artist B','artist-b','2021-12-13 12:23:12','2021-12-13 12:23:12'),
(3,'Artist C','artist-c','2021-12-13 13:12:56','2021-12-13 13:12:56'),
(4,'Artist D','artist-d','2021-12-13 14:01:15','2021-12-13 14:01:15'),
(5,'Artist E','artist-e','2021-12-14 12:12:03','2021-12-14 12:12:03'),
(6,'Artist F','artist-f','2021-12-14 13:54:23','2021-12-14 13:54:23'),
(7,'Artist G','artist-g','2021-12-11 15:34:21','2021-12-11 15:34:21'),
(8,'Artist H','artist-h','2021-12-13 12:23:12','2021-12-13 12:23:12'),
(9,'Artist I','artist-i','2021-12-13 13:12:56','2021-12-13 13:12:56'),
(10,'Artist J','artist-j','2021-12-13 14:01:15','2021-12-13 14:01:15'),
(11,'Artist K','artist-k','2021-12-14 12:12:03','2021-12-14 12:12:03'),
(12,'Artist L','artist-l','2021-12-14 13:54:23','2021-12-14 13:54:23');

CREATE TABLE  song_artists (
 id int,
 song_id int,
 artist_id int );

INSERT INTO song_artists VALUES
(1,1,3),
(2,2,2),
(3,3,1),
(4,4,10),
(5,5,11),
(6,6,12),
(7,7,9),
(8,8,8),
(9,9,7),
(10,10,6),
(11,11,5),
(12,12,4),
(13,12,1);

id	name	url	createdAt	updatedAt	view_count
12	Artist L	artist-l	2021-12-14 13:54:23	2021-12-14 13:54:23	165
3	Artist C	artist-c	2021-12-13 13:12:56	2021-12-13 13:12:56	154
8	Artist H	artist-h	2021-12-13 12:23:12	2021-12-13 12:23:12	135
1	Artist A	artist-a	2021-12-11 15:34:21	2021-12-11 15:34:21	123
9	Artist I	artist-i	2021-12-13 13:12:56	2021-12-13 13:12:56	121
2	Artist B	artist-b	2021-12-13 12:23:12	2021-12-13 12:23:12	54
5	Artist E	artist-e	2021-12-14 12:12:03	2021-12-14 12:12:03	26
11	Artist K	artist-k	2021-12-14 12:12:03	2021-12-14 12:12:03	26
7	Artist G	artist-g	2021-12-11 15:34:21	2021-12-11 15:34:21	25
6	Artist F	artist-f	2021-12-14 13:54:23	2021-12-14 13:54:23	15