1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

;with mostQuestions
as
(
  select 
    p.owneruserid
    , count(1) as cnt 
  from 
    posts as p
  where
    p.posttypeid = 1 /* 1 = Question */
  group by 
    p.owneruserid
)
select top (25)
 mq.Cnt
 , u.DisplayName
 , u.CreationDate
 , datediff(day, CreationDate, getutcdate()) as DaysOld
from 
  mostQuestions as mq
  join Users as u
    on mq.owneruserId = u.Id
order by mq.cnt desc

fork query

edited jan 18

created jan 18 Zikato