Insert_t.sql - master - BARS-uk/bd_homework_3

Insert_t.sql
129 строк6 KB
BARS-uk
update Insert_t.sql
08 окт 2025, 10:57
08 окт 2025, 10:575c50fd0
INSERT INTO genre (name)
VALUES ('Rock'), ('Pop'), ('Jazz'), ('Folk');

INSERT INTO collection (name, year_of_release)
VALUES ('Легенды Даза', 2015), ('Белый рояль', 1968), ('Русский рок', 2019), ('Моя Россия', 2025);

INSERT INTO album (name, year_of_release)
VALUES ('Hello Dolly', 1993);

INSERT INTO track (album_id, name, duration)
VALUES (1, 'Hello Dolly', 148);

INSERT INTO track (album_id, name, duration)
VALUES (1, 'La Vie En Rose', 202), (1, 'Ramona', 164), (1,' Basin Street Blues', 252), (1, 'Only You', 193);

INSERT INTO singer (nick_name)
VALUES ('Louis Armstrong');

INSERT INTO singeralbum (singer_id, album_id)
VALUES (1, 1);

INSERT INTO trackcollection (track_id, collection_id)
VALUES (1, 1), (5, 1);

INSERT INTO singergenre (singer_id, genre_id)
VALUES (1, 3);

INSERT INTO album (name, year_of_release)
VALUES ('Members Edition', 2003);

INSERT INTO track (album_id, name, duration)
VALUES (2, 'Night and Day', 146), (2, 'After I Say I am Sorry', 96), (2, 'Begin tne Beguine', 189);

INSERT INTO singer (nick_name)
VALUES ('Frank Sinatra');

INSERT INTO singeralbum (singer_id, album_id)
VALUES (2, 2);

INSERT INTO trackcollection (track_id, collection_id)
VALUES (6, 1), (8, 1);

INSERT INTO singergenre (singer_id, genre_id)
VALUES (2, 3);

INSERT INTO album (name, year_of_release)
VALUES ('Christmas Mood', 2024);

INSERT INTO track (album_id, name, duration)
VALUES (3, 'Little Brown Jug', 169), (3, 'In The Mood', 190), (3, 'Pennsylvania 6-5000', 182), (3, 'Sunrise Serenade', 214);

INSERT INTO singer (nick_name)
VALUES ('Glenn Miller');

INSERT INTO singeralbum (singer_id, album_id)
VALUES (3, 3);

INSERT INTO trackcollection (track_id, collection_id)
VALUES (9, 1), (10, 1), (12, 1);

INSERT INTO singergenre (singer_id, genre_id)
VALUES (3, 3);

INSERT INTO album (name, year_of_release)
VALUES ('Антология советской песни', 1971), ('С любовью к женщине', 2003);

INSERT INTO track
VALUES (13, 4, 'Дорожная', 149), (14, 4, 'Первая весна', 144), (15, 4, 'Я буду ждать тебя', 152), (16, 4, 'Пусть летят журавли', 209), 
	   (17, 5, 'Лунная серенада', 184), (18, 5, 'Мелодия', 282), (19, 5, 'С любовью к женщине', 247), (20, 5, 'Нам не жить друг без друга', 285), (21, 5, 'Солнце любви твоей', 326);

INSERT INTO singer (nick_name)
VALUES ('Аида Ведищева'), ('Муслим Магомаев');

INSERT INTO singeralbum (singer_id, album_id)
VALUES (4, 4), (5, 5);

INSERT INTO trackcollection (track_id, collection_id)
VALUES (13, 2), (14, 2), (15, 2), (17, 2);

INSERT INTO singergenre (singer_id, genre_id)
VALUES (4, 2), (5, 2);

INSERT INTO album (name, year_of_release)
VALUES ('Сейчас позднее, чем ты думаешь', 2003), ('Избранное', 2002), ('Просвистела', 1999);

INSERT INTO track
VALUES (22, 6, 'Небо славян', 276), (23, 6, 'Родина', 244), (24, 6, 'Непокорные', 233), (25, 6, 'Душа', 409), 
	   (26, 7, 'Как на войне', 245), (27, 7, 'Сказочная тайга', 172), (28, 7, 'Черная луна', 236), (29, 7, 'Пантера', 199),
	   (30, 8, 'Просвистела', 222), (31, 8, 'Дождь', 307), (32, 8, 'Что такое осень', 300), (33, 8, 'Белая река', 298);

INSERT INTO singer (nick_name)
VALUES ('Алиса'), ('Агата Кристи'), ('ДДТ');

INSERT INTO singeralbum (singer_id, album_id)
VALUES (6, 6), (7, 7), (8, 8);

INSERT INTO trackcollection (track_id, collection_id)
VALUES (22, 3), (24, 3), (25, 3), (27, 3), (28, 3), (31, 3), (32, 3), (33, 3);

INSERT INTO singergenre (singer_id, genre_id)
VALUES (6, 1), (7, 1), (8, 1);

INSERT INTO album (name, year_of_release)
VALUES ('Пташечка', 2019), ('У истока', 2024), ('Душа нараспашку', 2024);

INSERT INTO track
VALUES (34, 9, 'Вьюн над водой', 234), (35, 9, 'Пташечка', 353), (36, 9, 'Я ехала домой', 144), (37, 9, 'Розы', 276),
       (38, 9, 'Конь', 291), (39, 9, 'Черный ворон', 236), (40, 9, 'Белым снегом', 220),
	   (41, 10, 'У истока', 221), (42, 10, 'Матушка', 173), (43, 10, 'Ромашка-василек', 245), (44, 10, 'Одного', 193), (45, 10, 'Ты родная мне', 221),
	   (46, 11, 'Встанем', 239), (47, 11, 'Я русский', 210), (48, 11, 'Моя Россия', 155), (49, 11, 'Душа нараспашку', 180),
	   (50, 11, 'Вороны мои', 180), (51, 11, 'Отец', 210), (52, 11, 'Исповедь', 155), (53, 11, 'Настоящий мужчина', 171);
	   
INSERT INTO track
VALUES (54, 11, 'Мой бой', 145);   

INSERT INTO singer (nick_name)
VALUES ('Пелагея'), ('Татьяна Куртукова'), ('SHAMAN'), ('Эльмира Калимулина'), ('Анри Гогниашвили'), ('Мария Гойя'), ('Григорий Лепс');

INSERT INTO singer (nick_name)
VALUES ('Егор Бахарев');

INSERT INTO singeralbum (singer_id, album_id)
VALUES (9, 9), (10, 10), (11, 11), (12, 9), (13, 9), (14, 9), (15, 11), (16, 11);
	    
INSERT INTO trackcollection (track_id, collection_id)
VALUES (35, 4), (37, 4), (39, 4), (41, 4), (42, 4), (45, 4), (46, 4), (47, 4), (48, 4), (49, 4), (51, 4), (52, 4);

INSERT INTO singergenre (singer_id, genre_id)
VALUES (9, 4), (10, 4), (11, 2), (11, 4), (12, 4), (13, 4), (14, 4), (15, 2), (16, 2);