Q&A for active researchers, academics and students of physics
-- Which tags had the most bounties offered in past 30 days? SELECT COUNT(*) AS Bounty_Num, SUM(Votes.BountyAmount) AS Bounty_Amt, Tags.TagName FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.Id = PostTags.PostId AND Posts.PostTypeId = 1 AND Posts.CreationDate >= DATEADD(day,-30,GETDATE()) AND Posts.CreationDate <= GETDATE() INNER JOIN Votes ON Votes.PostId = Posts.Id AND Votes.VoteTypeId = 8 -- BountyStart GROUP BY TagName ORDER BY Bounty_Num DESC