0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT U.Id AS UserId,
       U.DisplayName AS UserName,
       B.Name,
       CASE B.Class WHEN 1 THEN 'Gold'
                    WHEN 2 THEN 'Silver'
                    WHEN 3 THEN 'Bronze'
       END AS Class
FROM dbo.Badges B
     JOIN dbo.Users U On B.UserId = U.Id
WHERE B.TagBased = 1
AND B.Date BETWEEN '2024-10-30 16:00:00' AND '2024-10-30 16:20:00'
ORDER BY B.Date

fork query

edited nov 11 anonymous

created nov 3 Dimitri M