Q&A for committed Christians, experts in Christianity and those interested in learning more
SELECT v.UserId AS [User Link], 'site://suggested-edits/' + CAST(v.SuggestedEditId AS NVARCHAR) AS 'Suggested edit', v.CreationDate AS 'Date', CASE v.VoteTypeId WHEN 2 THEN 'Approve' ELSE 'Reject' END AS 'Vote' FROM SuggestedEditVotes AS v INNER JOIN ( SELECT v.SuggestedEditId, ROUND(AVG(CAST(v.VoteTypeId AS FLOAT)), 0) AS 'Outcome' FROM SuggestedEditVotes AS v WHERE v.CreationDate >= ##startDate:string?2019-01-01## AND v.UserId != -1 -- Community GROUP BY v.SuggestedEditId HAVING COUNT(*) = 3 -- 2+1 vote ) AS temp ON v.SuggestedEditId = temp.SuggestedEditId WHERE v.VoteTypeId != temp.Outcome ORDER BY CreationDate DESC