0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

-- Questions with bounty

Select count(*) as "#Bounty Question"


From Posts q
  Join Votes v On v.PostId = q.Id
  Join POsts a On a.ParentId = q.Id
  

Where q.PostTypeId = 1 And
      v.BountyAmount > 0 And
      v.CreationDate < a.CreationDate And
      a.CreationDate < v.CreationDate + 7

fork query

edited dec 2

created dec 2 MdoubleDash