0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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

fork query

edited nov 11 anonymous

created nov 3 Dimitri M