0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT ROW_NUMBER() OVER(ORDER BY Score DESC) AS [#], us.id [User Link],
       us.DisplayName,
       tuser.Score
       
FROM Users us

JOIN 
(SELECT Answers.OwnerUserId AS UserId, SUM(Answers.Score) AS Score
     FROM Tags 
    JOIN PostTags ON Tags.Id = PostTags.TagId
    JOIN Posts ON Posts.Id = PostTags.PostId  
    JOIN Posts Answers ON Answers.ParentId = Posts.Id 
  WHERE Tags.TagName IN ( 
--    '.net' 
-- , '.net-4.0' 
--'.net-core' 
 'asp.net-core' 
-- , 'asp.net-core-2.0' 
-- , 'asp.net-core-2.2' 
-- , 'asp.net-core-3.0' 
-- , 'asp.net-core-3.1' 
-- , 'asp.net-core-mvc' 
-- , 'asp.net-identity' 
-- , 'asp.net-mvc '
-- , 'asp.net-mvc-2' 
-- , 'asp.net-mvc-3' 
-- , 'asp.net-mvc-4' 
-- , 'asp.net-mvc-5' 
-- , 'asp.net-web-api' 
-- , 'asp.net-web-api2'
-- , 'async-await '
-- 'c#' 
-- , 'c#-4.0 '
-- --, 'cmd' 
-- , 'database' 
-- , 'database-design' 
-- , 'datagridview' 
-- --, 'datatable' 
-- --, 'datatables' 
-- , 'datetime' 
-- , 'debugging' 
-- , 'dependency-injection' 
-- , 'design-patterns' 
-- --, 'dictionary' 
-- , 'dll' 
-- , 'ef-code-first' 
-- , 'ef-core-2.0' 
-- , 'ef-core-2.1' 
-- , 'ef-core-2.2' 
-- , 'ef-core-3.0' 
-- , 'ef-core-3.1' 
-- , 'entity-framework' 
-- , 'entity-framework-4' 
-- , 'entity-framework-core' 
-- , 'foreach' 
-- --, 'function' 
-- , 'github' 
-- 'go' 
-- , 'group-by' 
-- --, 'http' 
-- , 'iis' 
-- , 'iis-7' 
-- , 'iis-10'
-- , 'join' 
)
  GROUP BY Answers.OwnerUserId
) tuser ON tuser.UserId = us.Id

WHERE lower(us.Location) like '%iran%'
ORDER BY Score DESC;

fork query

edited feb 6 23 Hamed.Aali

created aug 4 16 Chathuranga.Silva