Q&A about the site for gardeners and landscapers
;WITH tmp AS (SELECT p.AnswerCount AS ACount, Period = DATEPART("weekday", bs.CreationDate) FROM Posts p INNER JOIN Votes bs ON p.Id = bs.PostId AND bs.VoteTypeId = 8 -- BountyStart ) SELECT Period, AVG(cast(ACount as decimal)) FROM tmp GROUP BY Period ORDER BY Period