Q&A for science fiction and fantasy enthusiasts
--Yerevan Android devs --https://data.stackexchange.com/stackoverflow/query/edit/1178712#resultSets ---------------------- ;WITH USER_BY_TAG AS ( SELECT ROW_NUMBER() OVER(ORDER BY COUNT(*) DESC) Rank, u.Location, u.DisplayName, u.Id, COUNT(*) AS UpVotes FROM Tags t INNER JOIN PostTags pt ON pt.TagId = t.id INNER JOIN Posts p ON p.ParentId = pt.PostId INNER JOIN Votes v ON v.PostId = p.Id and VoteTypeId = 2 INNER JOIN Users u ON u.Id = p.OwnerUserId WHERE (LOWER(Location) LIKE '% armenia%') AND TagName = 'android' GROUP BY u.Location,u.DisplayName,u.Id ) SELECT * FROM USER_BY_TAG ORDER BY upvotes DESC ;