Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources
SELECT -- se.OwnerUserId, p.PostTypeId AS NumPosts, count(*), count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) IS NULL) AND (LEN(se.Title) IS NULL) THEN 1 ELSE NULL END) AS TagOnlyEdits, count(CASE WHEN (LEN(se.Tags) IS NULL) AND (LEN(se.Text) > 0) AND (LEN(se.Title) IS NULL) THEN 1 ELSE NULL END) AS TextOnlyEdits, count(CASE WHEN (LEN(se.Tags) IS NULL) AND (LEN(se.Text) IS NULL) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TitleOnlyEdits, count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) > 0) AND (LEN(se.Title) IS NULL) THEN 1 ELSE NULL END) AS TagTitleEdits, count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) IS NULL) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TagTextEdits, count(CASE WHEN (LEN(se.Tags) IS NULL) AND (LEN(se.Text) > 0) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TitleTextEdits, count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) > 0) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TagTextTitleEdits FROM SuggestedEdits se LEFT JOIN Posts p ON p.Id = se.PostId WHERE se.RejectionDate is NULL AND se.ApprovalDate is NULL -- AND (p.PostTypeId = 1 OR p.PostTypeId = 2) GROUP BY p.PostTypeId -- ORDER BY TagOnlyEdits DESC