Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
-- I just want to earn Marshal badge DECLARE @LastWeek DateTime = dateadd(day, datediff(day, 8, GETDATE()), 0) -- Answers that are complained by the bot SELECT TOP 500 p.Id [Post Link], p.Body FROM Posts p JOIN Comments c ON p.Id = c.PostId WHERE p.PostTypeId = 2 AND p.DeletionDate IS NULL AND c.UserId = -1 AND c.Text LIKE '%your answer is unclear%' ORDER BY c.CreationDate DESC -- Answers that are suspiciously short SELECT TOP 100 Id AS [Post Link], Body, LEN(Body) Length FROM Posts WHERE CreationDate >= @LastWeek AND PostTypeId = 2 AND LEN(Body) <= 120 ORDER BY Length ASC