Top users answering questions for a specific tag

3

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 OwnerUserId as [User Link], count(*) as Count
from Posts
where ParentId in 
  (
  select Id
  from Posts
  where tags like '%' + ##tag:string## + '%'
    and PostTypeId = 1
    and LastActivityDate > DATEADD(year,-1,GETDATE())
  )
group by OwnerUserId
order by Count desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results