Active ITA Users by Reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT ROW_NUMBER() OVER (ORDER BY Reputation desc, LastAccessDate desc) AS Rank,
       Id AS [User Link],
       Reputation, LastAccessDate, Location, UpVotes, DownVotes
FROM Users u
WHERE 
    (UPPER(Location) LIKE 'ITA%' 
     OR UPPER(Location) LIKE '% ITA%'
    )
    AND Reputation >= ##MinReputation:int?3000##
    AND LastAccessDate >= getdate() - ##DaysAgo:int?10##

Enter Parameters

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