Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select artist.name, area.name, count(release.*)
- from area_type join area on (area_type.id=area.type and area_type.name='Country') join artist on (area.id=artist.area)
- join artist_credit_name on (artist.id=artist_credit_name.artist) join artist_credit on
- (artist_credit.id=artist_credit_name.artist_credit) join release on (artist_credit.id=release.artist_credit)
- where area.name='United Kingdom'
- group by artist.name, area.name
- having count(release.*) >= 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement