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)

Literature

Q&A for scholars and enthusiasts of literature

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, Users u,
(select p2.Id as id
from Posts p1, Posts p2, PostTags pt
where p1.Id = p2.ParentId and p1.Id = pt.PostId
and (pt.TagId=100570 or pt.TagId=40102 or pt.TagId=109466 or pt.TagId=116033 or pt.TagId=113994 or pt.TagId=24100 or pt.TagId=99347 or pt.TagId=132868)
and p1.PostTypeid=1 and p2.PostTypeid=2 
and p2.CreationDate>=cast('2015-03-01' as datetime) 
and p2.CreationDate<=cast('2017-03-31' as datetime) 
) answer
where p.OwnerUserId=u.Id and answer.id = p.Id
group by p.OwnerUserId

Enter Parameters

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