Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.Country, COUNT(m.ID)
- FROM MEMBER m, SUPPORTSTAFF s, TEAMMEMBER t, TEAM e
- WHERE m.ID = s.ID
- AND t.MemberID = m.ID
- AND t.TeamID = e.ID
- AND e.YEAR = 2018
- GROUP BY e.Country
- ORDER BY COUNT(m.ID) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement