Individual user who answered the most of all question posts given the tag and answer post duration

1

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 1 u2.displayname,
         count(*) AS "ANSWERS"
  from   Posts p2, Users u2,
         (select  p1.id
            from  Posts p1, PostTypes ptypes1, PostTags ptags1, Tags t1
           where  p1.posttypeid = ptypes1.id
             and  ptypes1.id = 1
             and  p1.id = ptags1.postid
             and  ptags1.tagid = t1.id
             and  t1.tagname = '##TagName##'
         ) AS q2
where    p2.parentid = q2.id
  and    p2.owneruserid = u2.id
  and    p2.CreationDate >= '##startdate##'
  and    p2.CreationDate <= '##enddate##'
group by u2.displayname
order by ANSWERS DESC

Enter Parameters

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