Preguntas y respuestas para programadores y profesionales de la informática
-- How many edits do I have? -- Counts how many edits a user has, broken into Question and Answer edits. -- Also shows how close you are to getting each editor badge. WITH qaedits AS ( SELECT ( SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1 AND LastEditorUserId = Users.Id AND LastEditDate='2018-07-13' ) AS QuestionEdits, ( SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND LastEditorUserId = Users.Id ) AS AnswerEdits FROM Users WHERE Id = ##UserId## ), edits AS ( SELECT QuestionEdits, AnswerEdits, QuestionEdits + AnswerEdits AS TotalEdits FROM qaedits ) SELECT QuestionEdits, AnswerEdits, TotalEdits, CASE WHEN TotalEdits >= 1 THEN 'Received' ELSE '0%' END AS EditorBadge, CASE WHEN TotalEdits >= 80 THEN 'Received' ELSE Cast(TotalEdits AS varchar) + '%' END AS StrunkAndWhiteBadge, CASE WHEN TotalEdits >= 500 THEN 'Received' ELSE Cast(TotalEdits / 5 AS varchar) + '%' END AS CopyEditorBadge FROM edits