Q&A for professionals, academics, and students working within the systems development life cycle
SELECT Posts.OwnerUserId AS [User Link], SUM(CASE WHEN Votes.VoteTypeId = 2 THEN 10 ELSE -2 END) AS ScoreFromDuplicates, MIN(Users.Reputation) AS Reputation FROM Posts INNER JOIN Users ON Users.Id = Posts.OwnerUserId INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE Users.Reputation > 1000 AND Votes.VoteTypeId IN (2, 3) AND Posts.CreationDate >= DATEADD(DAY, -30, GETDATE()) AND Posts.CreationDate <= GETDATE() AND Posts.ParentID IN (SELECT Posts.Id FROM Posts INNER JOIN PostHistory ON PostHistory.PostId = Posts.Id WHERE Posts.CreationDate >= DATEADD(DAY, -30, GETDATE()) AND Posts.CreationDate <= GETDATE() AND TRY_CONVERT(int, PostHistory.Comment) IN (1, 101) AND PostHistory.PostHistoryTypeId = 10) GROUP BY Posts.OwnerUserId ORDER BY ScoreFromDuplicates DESC