ITA Rank by Badge

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

DECLARE @badgeName nvarchar(50)  = '##badgeName?node.js##'

SELECT
       ROW_NUMBER() OVER (ORDER BY u.Reputation desc, u.LastAccessDate desc) AS Rank,
       u.Id AS [User Link],
       u.Reputation, u.Location, u.LastAccessDate
FROM Badges b INNER JOIN Users u ON b.UserId = u.Id
WHERE 
    b.Name = @badgeName
    AND
    (UPPER(u.Location) LIKE 'ITA%' 
     OR UPPER(u.Location) LIKE '% ITA%'
    )

Enter Parameters

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