Q&A for professional, enthusiast and amateur photographers
-- How many of closed bounties have been awarded?
(select count(*) as Amount from Votes where VoteTypeId=9),
(select count(*) as Amount from Votes inner join Posts on (Votes.PostID=Posts.Id) where VoteTypeId=9 and Posts.ParentId is not null)
BountyCloses.Amount as ClosedBounties,
BountyAwards.Amount as AwardedBounties,