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;