Advertisement
This is comment for paste
Подзапросы в WHERE, задача 4
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- необходимо добавить псевдонимы
- SELECT g.name
- FROM genre AS g
- JOIN track AS t ON g.genre_id = t.genre_id
- WHERE t.track_id IN
- (SELECT track_id
- FROM track
- ORDER BY milliseconds
- LIMIT 2)
- ORDER BY t.milliseconds;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement