Shows answers for a tag that have been awarded bounties, most recent answers first.
Q&A for programmers
-- Answers awarded bounties by tag
-- Shows answers for a tag that have been awarded bounties, most recent answers first.
SELECT post.Id AS [Post Link],
vote.BountyAmount AS Bounty,
post.CreationDate AS Date,
FROM Posts post
JOIN Votes vote ON vote.PostId = post.Id
JOIN Posts parent ON post.ParentId = parent.Id
vote.VoteTypeId = 9 AND
vote.BountyAmount <> 0 AND
parent.Tags LIKE '%<##Tag##>%'
ORDER BY post.CreationDate DESC
Error: looks like you typed in the wrong words - try again