Number_1.sql - main - ssstrekoza/Work_with_SQL

Number_1.sql
413 строк10 KB
Elena Dekho
Numbers 1, 2, 3, 4 added
12 окт 2025, 04:03
12 окт 2025, 04:034f4e3c0
-- Задание 1
-- Заполняем базу данных

insert into performer (performer_name)
values ('Allan Rayman');

insert into performer (performer_name)
values ('Hemi Moore');

insert into performer (performer_name)
values ('Davit Barqaia');

insert into performer (performer_name)
values ('Secret Garden');

insert into performer (performer_name)
values ('Alex Spite');

insert into genre (genre_name)
values ('Sad');

insert into genre_performers (genre_id, performer_id)
values (1, 1);

insert into album (album_name, release_year)
values ('Roadhouse 01', 2017);

insert into album_artists (album_id, performer_id)
values (1, 1);

insert into genre (genre_name)
values ('Calm');

insert into genre_performers (genre_id, performer_id)
values (2, 2);

insert into album (album_name, release_year)
values ('Against the Wind', 2024);

insert into album_artists (album_id, performer_id)
values (2, 2);

insert into genre (genre_name)
values ('Pop');

insert into genre_performers (genre_id, performer_id)
values (3, 3);

insert into album (album_name, release_year)
values ('My Time', 2021);

insert into album_artists (album_id, performer_id)
values (3, 3);

insert into genre_performers (genre_id, performer_id)
values (2, 4);

insert into album (album_name, release_year)
values ('Earthsongs', 2005);

insert into album_artists (album_id, performer_id)
values (4, 4);

insert into genre_performers (genre_id, performer_id)
values (3, 5);

insert into album (album_name, release_year)
values ('Gray Night', 2023);

insert into album_artists (album_id, performer_id)
values (5, 5);

insert into genre (genre_name)
values ('Dance');

insert into performer (performer_name)
values ('Dua Lipa');

insert into genre_performers (genre_id, performer_id)
values (4, 6);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Left Alone', 143, 1);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Poison Ivy', 171, 2);

INSERT INTO track (track_name, duration, album_id)
VALUES ('My Time', 261, 3);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Lotus', 276, 4);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Gray Night', 309, 5);

insert into album (album_name, release_year)
values ('Future Nostalgia', 2020);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Levitating', 204, 6);

insert into album (album_name, release_year)
values ('Midnights', 2022);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Lavender Haze', 202, 7);

insert into collection (collection_name, release_year)
values ('Guardians of the Galaxy: Awesome Mix Vol. 1 (Original Motion Picture Soundtrack)', 2014);

insert into collection (collection_name, release_year)
values ('Fifty Shades of Grey: Original Motion Picture Soundtrack', 2015);

insert into collection (collection_name, release_year)
values ('Now That’s What I Call Music! 100', 2022);

insert into collection (collection_name, release_year)
values ('Barbie: The Album', 2023);

insert into collection (collection_name, release_year)
values ('Triple J Hottest 100, 2023', 2024);

insert into collection (collection_name, release_year)
values ('Now That’s What I Call Music! 70', 2019);

insert into collection (collection_name, release_year)
values ('Spider-Man: Into the Spider-Verse (Original Motion Picture Soundtrack)', 2018);

insert into performer (performer_name)
values ('Sia');

insert into album (album_name, release_year)
values ('Folklore', 2020);

insert into album (album_name, release_year)
values ('When We All Fall Asleep, Where Do We Go?', 2019);

INSERT INTO track (track_name, duration, album_id)
VALUES ('The 1', 210, 8);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Cardigan', 239, 8);

INSERT INTO track (track_name, duration, album_id)
VALUES ('The last great american dynasty', 230, 8);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Exile', 285, 8);

INSERT INTO track (track_name, duration, album_id)
VALUES ('My tears ricochet', 255, 8);

INSERT INTO track (track_name, duration, album_id)
VALUES ('My tears ricochet', 255, 8);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Bad guy', 194, 9);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Xanny', 245, 9);

INSERT INTO track (track_name, duration, album_id)
VALUES ('You should see me in a crown', 181, 9);

INSERT INTO track (track_name, duration, album_id)
VALUES ('All the good girls go to hell', 168, 9);

insert into performer (performer_name)
values ('The Weeknd');

insert into album (album_name, release_year)
values ('Everything Is Love', 2018);

insert into album (album_name, release_year)
values ('Watch the Throne', 2011);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Wolf', 232, 1);

INSERT INTO track (track_name, duration, album_id)
VALUES ('December', 240, 1);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Something in the Waters', 190, 2);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Faith', 191, 2);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Answer', 161, 2);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Sometines when it Rains', 279, 4);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Cool', 210, 6);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Maroon', 218, 7);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Summer', 232, 10);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Apeshit', 246, 10);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Niggas in Paris', 217, 11);

INSERT INTO track (track_name, duration, album_id)
VALUES ('New Day', 250, 11);

insert into genre_performers (genre_id, performer_id)
values (3, 7);

insert into genre (genre_name)
values ('R&B');

insert into genre_performers (genre_id, performer_id)
values (5, 8);

insert into album_artists (album_id, performer_id)
values (6, 6);

insert into performer (performer_name)
values ('Taylor Swift');

insert into album_artists (album_id, performer_id)
values (7, 9);

insert into genre_performers (genre_id, performer_id)
values (3, 9);

insert into album_artists (album_id, performer_id)
values (8, 9);

insert into performer (performer_name)
values ('Billie Eilish');

insert into album_artists (album_id, performer_id)
values (9, 10);

insert into genre (genre_name)
values ('Alternative');

insert into genre_performers (genre_id, performer_id)
values (6, 10);

insert into performer (performer_name)
values ('Beyoncé');

insert into performer (performer_name)
values ('Jay-Z');

insert into album_artists (album_id, performer_id)
values (10, 11);

insert into album_artists (album_id, performer_id)
values (10, 12);

insert into genre_performers (genre_id, performer_id)
values (5, 11);

insert into genre (genre_name)
values ('Hip-hop');

insert into genre_performers (genre_id, performer_id)
values (7, 12);

insert into album_artists (album_id, performer_id)
values (11, 12);

insert into genre (genre_name)
values ('Rap');

insert into performer (performer_name)
values ('Kanye West');

insert into album_artists (album_id, performer_id)
values (11, 13);

insert into genre_performers (genre_id, performer_id)
values (8, 13);

insert into genre (genre_name)
values ('Rock');

insert into performer (performer_name)
values ('Blue Swede');

insert into genre_performers (genre_id, performer_id)
values (9, 14);

insert into album (album_name, release_year)
values ('Hooked on a Feeling', 1974);

insert into album_artists (album_id, performer_id)
values (12, 14);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Hooked on a Feeling', 172, 12);

insert into tracks_in_collections (track_id, collection_id)
values (32, 1);

insert into genre_performers (genre_id, performer_id)
values (5, 11);

insert into album (album_name, release_year)
values ('Fifty Shades of Grey: Original Motion Picture Soundtrack', 2015);

insert into album_artists (album_id, performer_id)
values (13, 11);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Meet Me in the Morning', 214, 13);

insert into tracks_in_collections (track_id, collection_id)
values (33, 2);

insert into performer (performer_name)
values ('Harry Styles');

insert into genre_performers (genre_id, performer_id)
values (3, 15);

insert into album (album_name, release_year)
values ('Harry’s House', 2022);

insert into album_artists (album_id, performer_id)
values (14, 15);

INSERT INTO track (track_name, duration, album_id)
VALUES ('As It Was', 167, 14);

insert into tracks_in_collections (track_id, collection_id)
values (34, 3);

insert into album (album_name, release_year)
values ('Barbie: The Album', 2023);

insert into album_artists (album_id, performer_id)
values (15, 6);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Dance the Night', 185, 15);

insert into tracks_in_collections (track_id, collection_id)
values (35, 4);

insert into performer (performer_name)
values ('Troye Sivan');

insert into genre_performers (genre_id, performer_id)
values (4, 16);

insert into album (album_name, release_year)
values ('Something to Give Each Other', 2023);

insert into album_artists (album_id, performer_id)
values (16, 16);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Stranger', 193, 16);

insert into tracks_in_collections (track_id, collection_id)
values (36, 5);

insert into performer (performer_name)
values ('Lil Nas X');

insert into genre_performers (genre_id, performer_id)
values (8, 17);

insert into album (album_name, release_year)
values ('7 EP', 2019);

insert into album_artists (album_id, performer_id)
values (17, 17);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Old Town Road', 157, 17);

insert into tracks_in_collections (track_id, collection_id)
values (37, 6);

insert into performer (performer_name)
values ('Post Malone');

insert into performer (performer_name)
values ('Swae Lee');

insert into genre_performers (genre_id, performer_id)
values (6, 18);

insert into genre_performers (genre_id, performer_id)
values (5, 19);

insert into album (album_name, release_year)
values ('Spider-Man: Into the Spider-Verse (Original Motion Picture Soundtrack)', 2018);

insert into album_artists (album_id, performer_id)
values (18, 18);

insert into album_artists (album_id, performer_id)
values (18, 19);

INSERT INTO track (track_name, duration, album_id)
VALUES ('Sunflower', 158, 18);

insert into tracks_in_collections (track_id, collection_id)
values (38, 7);