0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

select userid as [User Link]
     , reputation
     , [gradle]      -- gradle batch
from
(
  select userid         -- userid is our group
       , [gradle]      -- gradle batch
  from (
    select id
         , userid
         , name 
    from badges
    where tagbased = 1
  ) as data
  pivot 
  (
    count(data.id)          -- count the number of badges per user per badge
    for name in (
      [gradle]       -- gradle batch
    ) 
  ) pvt
  where [gradle]     = 3  -- criteria for gradle badge
) main 
inner join users u on u.id = main.userid -- for reputation
order by displayname

fork query

created may 20 21 anonymous