Guest User

Untitled

a guest
Dec 14th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. %%sql
  2. SELECT tracks.*
  3.  
  4. FROM tracks
  5.  
  6. JOIN genres USING (GenreId)
  7.  
  8. JOIN media_types USING (MediaTypeId)
  9.  
  10. WHERE genres.Name = 'Rock'
  11.  
  12. AND media_types.Name = 'MPEG audio file'
  13.  
  14. ORDER BY tracks.Bytes DESC
  15.  
  16. LIMIT 10;
Add Comment
Please, Sign In to add comment