Q&A about the site for active researchers, academics and students of physics
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