/
Anna99
/
SQL_code2
Обзор
Документация
Войти
/
Anna99
/
SQL_code2
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
SELECT.SQL.ру
50 строк
1 KB
Anna99
SELECT.SQL.ру
30 окт 2025, 16:22
30 окт 2025, 16:22
0d052d9
Код
Авторство
О чём код?
SELECT title, duration FROM Track ORDER BY duration DESC LIMIT 1; SELECT title FROM Track WHERE duration >= 3.5; SELECT title FROM Compilation WHERE release_year BETWEEN 2018 AND 2020; SELECT name FROM Artist WHERE name NOT LIKE '% %'; SELECT title FROM Track WHERE title LIKE '%мой%' OR title LIKE '%my%'; SELECT g.name AS genre, COUNT(ag.artist_id) AS artist_count FROM Genre g LEFT JOIN ArtistGenre ag ON g.genre_id = ag.genre_id GROUP BY g.genre_id, g.name; SELECT COUNT(t.track_id) AS track_count FROM Track t JOIN Album a ON t.album_id = a.album_id WHERE a.release_year BETWEEN 2019 AND 2020; SELECT a.title AS album, AVG(t.duration) AS avg_duration FROM Album a JOIN Track t ON a.album_id = t.album_id GROUP BY a.album_id, a.title; SELECT name FROM Artist WHERE artist_id NOT IN ( SELECT aa.artist_id FROM ArtistAlbum aa JOIN Album a ON aa.album_id = a.album_id WHERE a.release_year = 2020 ); WITH Кино_треки AS ( SELECT t.track_id FROM Track t JOIN Album a ON t.album_id = a.album_id JOIN ArtistAlbum aa ON a.album_id