Active ITA Users by Reputation


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
    (UPPER(Location) LIKE 'ITA%' 
     OR UPPER(Location) LIKE '% ITA%'
    AND Reputation >= ##MinReputation:int?3000##
    AND LastAccessDate >= getdate() - ##DaysAgo:int?10##

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results