instruction: How much attention to Bounties generate on posts.
response: SELECT AVG(p.ViewCount), v.BountyAmount FROM Posts AS p INNER JOIN Votes AS v ON p.Id = v.PostId WHERE PostTypeId = 1 AND v.VoteTypeId = 8 AND p.CreationDate >= @StartDate AND p.CreationDate <= @EndDate GROUP BY v.BountyAmount