Q&A for Bitcoin crypto-currency enthusiasts
SELECT TOP 100 Id As [Post Link], Score, (SELECT Count(Id) FROM PostFeedback v WHERE p.Id = v.PostId AND v.VoteTypeId = 2) As Upmods, (SELECT Count(Id) FROM PostFeedback v WHERE p.Id = v.PostId AND v.VoteTypeId = 3) As Downmods FROM Posts p WHERE p.OwnerUserId = ##UserId## ORDER BY (SELECT Count(Id) FROM PostFeedback v WHERE p.Id = v.PostId AND v.VoteTypeId IN(2,3)) DESC