0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

select avg(usr.Reputation) from Posts post
join Users usr on usr.id=post.OwnerUserId
join PostTags pt on pt.PostId=post.id
join Tags tag on tag.id=pt.TagId
where {fn NOW()} - post.CreationDate < 30 
  and post.PostTypeId=1 
  and post.AnswerCount > 3
  and tag.TagName='homework'

fork query

edited jan 31 13 anonymous

created dec 11 12 Denis Tulskiy