Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT A.login, count(DISTINCT L.country)
- FROM Locations L, Authors A, Reads R, Books B
- WHERE L.ip = R.ip and R.bid = B.bid and A.aid = B.aid
- GROUP BY A.login
- HAVING count(DISTINCT L.country) >= 4
- ORDER BY A.login, count(L.country) DESC
Add Comment
Please, Sign In to add comment