INSERT.SQL.ру - master - Anna99/SQL_code1

INSERT.SQL.ру
41 строка2 KB
Anna99
INSERT.SQL.ру
30 окт 2025, 15:32
30 окт 2025, 15:32e3e6595
INSERT INTO Genre (name) VALUES ('Рок');
INSERT INTO Genre (name) VALUES ('Поп');
INSERT INTO Genre (name) VALUES ('Джаз');

INSERT INTO Artist (name) VALUES ('Кино');
INSERT INTO Artist (name) VALUES ('Звери');
INSERT INTO Artist (name) VALUES ('Ария');
INSERT INTO Artist (name) VALUES ('Алла Пугачёва');

INSERT INTO Album (title, release_year) VALUES ('Группа крови', 1988);
INSERT INTO Album (title, release_year) VALUES ('Районы-кварталы', 2004);
INSERT INTO Album (title, release_year) VALUES ('Герой асфальта', 1987);

INSERT INTO Track (title, duration, album_id) VALUES ('Группа крови', 4.45, 1);
INSERT INTO Track (title, duration, album_id) VALUES ('Звезда по имени Солнце', 3.55, 1);
INSERT INTO Track (title, duration, album_id) VALUES ('Районы-кварталы', 3.10, 2);
INSERT INTO Track (title, duration, album_id) VALUES ('До скорой встречи', 3.40, 2);
INSERT INTO Track (title, duration, album_id) VALUES ('Герой асфальта', 5.20, 3);
INSERT INTO Track (title, duration, album_id) VALUES ('Улица роз', 4.30, 3);

INSERT INTO Compilation (title, release_year) VALUES ('Лучшие рок-хиты 80-х', 2018);
INSERT INTO Compilation (title, release_year) VALUES ('Поп-музыка 2000-х', 2019);
INSERT INTO Compilation (title, release_year) VALUES ('Джазовые импровизации', 2020);
INSERT INTO Compilation (title, release_year) VALUES ('Золотые хиты русского рока', 2018);

INSERT INTO ArtistGenre (artist_id, genre_id) VALUES (1, 1); 
INSERT INTO ArtistGenre (artist_id, genre_id) VALUES (2, 2);  
INSERT INTO ArtistGenre (artist_id, genre_id) VALUES (3, 1);  
INSERT INTO ArtistGenre (artist_id, genre_id) VALUES (4, 2);  

INSERT INTO ArtistAlbum (artist_id, album_id) VALUES (1, 1); 
INSERT INTO ArtistAlbum (artist_id, album_id) VALUES (2, 2);  
INSERT INTO ArtistAlbum (artist_id, album_id) VALUES (3, 3);  


INSERT INTO CompilationTrack (compilation_id, track_id) VALUES (1, 1);  
INSERT INTO CompilationTrack (compilation_id, track_id) VALUES (1, 5); 
INSERT INTO CompilationTrack (compilation_id, track_id) VALUES (2, 3);  
INSERT INTO CompilationTrack (compilation_id, track_id) VALUES (3, 6);  
INSERT INTO CompilationTrack (compilation_id, track_id) VALUES (4, 1); 
INSERT INTO CompilationTrack (compilation_id, track_id) VALUES (4, 5);