Average Score for non-Bounty Questions asked since First Bounty

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

select AVG(p.Score * 1.0) Score
from Posts p
LEFT JOIN Votes v ON v.PostID = p.ID AND v.VoteTypeID = 8
WHERE p.PostTypeID=1 AND v.CreationDate IS NULL
  AND p.CreationDate >= '2009-01-27' and p.CreationDate < '2009-11-08'

Enter Parameters

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