Shows answers that have been awarded bounties, most recent answers first.
Q&A for electronics and electrical engineering professionals, students, and enthusiasts
-- Answers awarded bounties
-- Shows answers 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
ORDER BY post.CreationDate DESC