0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select Users.DisplayName,sum(Posts.PostTypeid) as "No. of questions"
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2011-03-20' and '2011-03-26'
and Posts.PostTypeid = 1
group by Users.DisplayName 
order by sum(Posts.PostTypeid)

view current version

edited oct 4 18

created oct 4 18 jon.doe29493