SELECT U.Id AS UserId, U.DisplayName AS UserName, B.Name,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results