Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)
Q&A for science fiction and fantasy enthusiasts
-- Top Users by Country -- Created by samliew (http://stackoverflow.com/users/584192/samuel-liew) SELECT ROW_NUMBER() OVER(ORDER BY u.Reputation DESC) AS [#], u.Id AS [User Link], u.Reputation FROM Users u INNER JOIN Comments c ON u.Id = c.UserId INNER JOIN Posts p ON p.Id = c.PostId INNER JOIN PostTags pt ON pt.PostId = p.Id INNER JOIN Tags t ON pt.TagId = t.Id WHERE LOWER(u.Location) LIKE LOWER('%##CountryName##%') AND LOWER(t.TagName) LIKE LOWER('%##TagName##%') GROUP BY u.Id, u.Reputation ORDER BY Reputation DESC;