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