Looks for posts with more than half the amount of downvotes as they have upvotes Ordered by upvotes
プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答
set nocount on select top 100 p.ParentId, p.Title, p.ViewCount, t.TagName from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where t.TagName in ('kubernetes', 'k8s', 'docker') and DATEDIFF(day, GETDATE(), p.CreationDate) < 180 order by ViewCount desc