Top 20 VBA/Excel Nerds for the past 30d

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 20
  a.owneruserid as [User Link],
  count (a.id) as numPosts,
  sum(a.score) as totScore,
  sum(len(body) - len(replace(body, ' ', '')) + 1) as WordCount

from
 posts a
  
where
a.creationdate >= dateadd(day,-30,getdate()) and  (a.tags like '%vba>%' 
or a.tags like '%excel%')
And a.PostTypeID = 1
group by a.owneruserid

order by sum (a.score) desc

Enter Parameters

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