Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- %%sql
- SELECT tracks.*
- FROM tracks
- JOIN genres USING (GenreId)
- JOIN media_types USING (MediaTypeId)
- WHERE genres.Name = 'Rock'
- AND media_types.Name = 'MPEG audio file'
- ORDER BY tracks.Bytes DESC
- LIMIT 10;
Add Comment
Please, Sign In to add comment