/
VladimirMakarov88
/
PostgresSQL_homework
Обзор
Документация
Войти
/
VladimirMakarov88
/
PostgresSQL_homework
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
INSERT_scripts.sql
85 строк
2 KB
VladimirMakarov88
upload files
19 янв 2026, 20:36
Верифицирован
19 янв 2026, 20:36
a01139e
Код
Авторство
О чём код?
INSERT INTO genres (name) values ('Rock'), ('Pop'), ('Classical'), ('Hip-Hop'), ('Electronic'), ('Punk Rock'); INSERT INTO artists (name) values ('The Offspring'), ('Adele'), ('Hans Zimmer'), ('Eminem'), ('The Prodigy'), ('Cockney Rejects'); INSERT INTO albums (title_name, year) values ('Americana', 1998), ('19', 2008), ('The magic of cinema', 2021), ('The Marshall Mathers', 2000), ('The Fat of the Land', 1997), ('Oi! Oi! Oi!', 1978), ('Magic To Be Murdered By', 2020); INSERT INTO tracks (track_name, length, albums_id) values ('Oi! Oi! Oi!', 323, 6), ('East End', 212, 6), ('Pretty Fly', 307, 1), ('The Kids Arent Alright', 259, 1), ('Make you feel my love', 332, 2), ('Chasing Pavements', 330, 2), ('Serial Thrilla', 503, 5), ('Smack my bitch up', 543, 5), ('Breathe', 410, 5), ('Stan', 310, 4), ('The real slim shady', 308, 4), ('Gun barrel', 270, 3), ('Now we are free', 210, 3), ('Godzilla', 330, 7), ('Leaving Heaven', 426, 7); INSERT INTO collections (collections_name, year) values ('The best of Rock', 2010), ('Electronic vibes', 2016), ('The pop Greatest Hits', 2023), ('Night Hits', 2020); INSERT INTO genres_artists (artists_id, genres_id) values (1, 6), (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6), (6, 1); INSERT INTO albums_artists (albums_id, artists_id) values (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6), (7, 4); INSERT INTO collections_tracks (collections_id, tracks_id) values (1, 1), (1, 2), (1, 3), (1, 4), (2, 7), (2, 8), (2, 9), (3, 5), (3, 6), (3, 10), (4, 10), (4, 11), (4, 12), (4, 13), (4, 9), (4, 14), (4, 15);