0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

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%'
    )

fork query

edited aug 6

created aug 6 Manuel Spigolon