TOP 20 VBA/EXCEL NERDS for the past 30d [CORRECTED]

1

Please login or register to vote for this query.

(click on this box to dismiss)

Users who have been most active in any VBA or EXCEL tags in the past month.

Stack Overflow

Q&A for professional and enthusiast programmers

-- the pre-forked version was forked up
select top 20
  rank() over (order by count (a.id) desc) as Rank,
  a.owneruserid as [User Link],
  count (a.id) as [# Answers],
  sum(a.score) as [Total Score],
  sum(len(a.body) - len(replace(a.body, ' ', '')) + 1) as WordCount
from posts a left outer join posts q
on a.parentid = q.id
where a.posttypeid=2 
  and (q.tags like '%vba>%' or q.tags like '%excel%')
  and a.creationdate >= dateadd(day,-30,getdate())
group by a.owneruserid
order by  count (a.id) desc

Enter Parameters

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