/
valek
/
homework-SQL-advanced-select
Обзор
Документация
Войти
/
valek
/
homework-SQL-advanced-select
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
task1
55 строк
1 KB
valek
update task1
18 янв 2026, 21:39
Верифицирован
18 янв 2026, 21:39
48dbfdb
Код
Авторство
О чём код?
INSERT INTO singers (name) VALUES ('Scorpions'), ('Queen'), ('Eminem'), ('Madonna'), ('Robbie Williams'); INSERT INTO genres (name) VALUES ('Rock'), ('Rap'), ('Pop'); INSERT INTO albums (title, release_year) VALUES ('Scorpions Live', 1978), ('Queen', 1973), ('The Eminem Show', 2002), ('Madonna', 1983), ('The Christmas Present', 2019); INSERT INTO tracks (title, duration, album_id) VALUES ('Pictured Life', '00:03:04', 1), ('In Trance', '00:05:22', 1), ('Keep Yourself Alive', '00:03:47', 2), ('My Fairy King', '00:04:08', 2), ('White America', '00:05:25', 3), ('my own', '00:04:13', 3), ('Lucky Star', '00:05:38', 4), ('I Know It', '00:03:47', 4), ('myself', '00:04:25', 5), ('Feel', '00:03:56', 5); INSERT INTO collections (title, release_year) VALUES ('Medley', 1995), ('My life', 1989), ('Summer', 2004), ('Believe in love', 2019); INSERT INTO singersgenres (singer_id, genre_id) VALUES (1, 1), (2, 1), (3, 2), (4, 3), (5, 3); INSERT INTO singersalbums (singer_id, album_id) VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5); INSERT INTO collectionstracks (collection_id, track_id) VALUES (1, 1), (1, 3), (1, 6), (1, 8), (1, 9), (2, 1), (2, 4), (2, 6), (3, 2), (3, 3), (3, 7), (4, 5), (4, 9), (4, 10);