0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

SELECT U.Id AS UserId,
       U.DisplayName AS UserName,
       B.Name,
       B.Date,
       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 17:00:00'
ORDER BY B.Date

view current version

edited nov 11 anonymous

created nov 3 Dimitri M