Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more
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 17:00:00' ORDER BY B.Date