1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

WITH badges_first AS (
  SELECT
    Class,
    Name,
    UserId,
    ROW_NUMBER() OVER(PARTITION BY Class, Name 
                      ORDER BY Date) AS rk
 
  FROM Badges
  WHERE TagBased = 1)
SELECT
  Name as TagName,
  COUNT(CASE WHEN Class = 1 THEN 1 ELSE NULL END) as Gold,
  COUNT(CASE WHEN Class = 2 THEN 1 ELSE NULL END) as Silver,
  COUNT(CASE WHEN Class = 3 THEN 1 ELSE NULL END) as Bronze
FROM badges_first
WHERE UserId = ##UserId##
GROUP BY Name
ORDER BY Name

view current version

edited nov 19 17

created nov 19 17 Martijn Pieters