Advertisement
Guest User

Untitled

a guest
Jul 20th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. select artist.name, area.name, count(release.*)
  2. from area_type join area on (area_type.id=area.type and area_type.name='Country') join artist on (area.id=artist.area)
  3. join artist_credit_name on (artist.id=artist_credit_name.artist) join artist_credit on
  4. (artist_credit.id=artist_credit_name.artist_credit) join release on (artist_credit.id=release.artist_credit)
  5. where area.name='United Kingdom'
  6. group by artist.name, area.name
  7. having count(release.*) >= 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement