0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of poker

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 ( pt.TagId=81490 or pt.TagId=82977 or pt.TagId=16712)
and p.PostTypeid=1 
and p.CreationDate>=cast('2015-03-01' as datetime) 
and p.CreationDate<=cast('2017-03-31' as datetime) 
group by p.OwnerUserId

fork query

edited oct 13 19

created oct 11 19 anonymous