Get users by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select tagname
     , case class 
       when 1 then 'gold' 
       when 2 then 'silver' 
       when 3 then 'bronze' 
       end [class]
     , count(*) [# awarded]
from tags t 
inner join badges b on b.name = t.tagname and b.tagbased = 1
where tagname = ##tagname:string?java##
group by tagname
       , class

Enter Parameters

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