Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)
Q&A for amateur radio enthusiasts
-- Top Users by location and tag (see http://stackoverflow.com/tags) -- Created by samliew (http://stackoverflow.com/users/584192/samuel-liew) -- Modified by sgryzko SELECT Users.Id AS [User Link], SUM(Questions.Score) AS Score, Tags.TagName FROM Posts as Questions INNER JOIN Users ON Questions.OwnerUserId = Users.Id INNER JOIN PostTags ON PostTags.PostId = Questions.Id INNER JOIN Tags on Tags.Id = PostTags.TagId WHERE LOWER(Location) LIKE LOWER('%##location##%') GROUP BY Users.Id, Tags.TagName ORDER BY Score DESC