select p.OwnerUserId, avg(u.Reputation) as reputation, av...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select p.OwnerUserId, avg(u.Reputation) as reputation, avg(u.Views) as views, avg(u.UpVotes) as upvote, avg(u.DownVotes) as downvote, min(u.CreationDate) as creation, avg(p.ViewCount) as user_qavgview_hist, avg(p.Score) as user_qavgscore_hist, avg(p.AnswerCount) as user_qavganswercount_hist, avg(p.CommentCount) as user_qavgcomment_hist, avg(p.FavoriteCount) as user_qavgfavs_hist, count(p.Id) as user_qcount_hist 
from Posts p,  PostTags pt, Users u
where p.OwnerUserId=u.Id and p.Id=pt.PostId
and p.PostTypeid=1 
and p.CreationDate>=cast('2012-07-01' as datetime) 
and p.CreationDate<=cast('2015-08-01' as datetime) 
group by p.OwnerUserId

Enter Parameters

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