DECLARE @from_date DATETIME DECLARE @test VARCHAR(255) S...

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

DECLARE @from_date DATETIME
DECLARE @test VARCHAR(255)

SET @from_date = CONVERT(DATETIME, Concat('01 JAN ', ##FromYear:int?2018## ), 106)


SELECT TOP 1000 users.id          AS [UserId],
                users.displayname AS [Name],
                users.reputation,
                Users.Location,
                Sum(posts.score)  AS [Score],
                Concat('https://stackoverflow.com/users/', users.id),
                Users.WebsiteUrl
FROM   users
       INNER JOIN posts
               ON posts.owneruserid = users.id
       INNER JOIN posttags
               ON posttags.postid = posts.parentid
       INNER JOIN tags
               ON tags.id = posttags.tagid
WHERE  users.creationdate > @from_date
AND Lower(tags.tagname) = Lower(##Technology:string?Java##)
       AND ( Lower(users.location) LIKE '%lanka%'
              OR Upper(users.location) LIKE '%colombo%' )
GROUP  BY users.id,
          users.displayname,
          users.reputation,
          Users.Location,
          Users.WebsiteUrl
         
ORDER  BY score DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results