Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
SELECT -- se.OwnerUserId, p.PostTypeId, count(*) AS NumPosts, -- count(CASE WHEN u.Reputation <= 100 THEN 1 ELSE NULL END) AS NewUsers, -- count(CASE WHEN u.Reputation > 100 AND u.Reputation <= 500 THEN 1 ELSE NULL END) AS LowerRepUsers, -- count(CASE WHEN u.Reputation > 500 THEN 1 ELSE NULL END) AS HigherRepUsers, CASE WHEN u.Reputation BETWEEN 0 AND 99 THEN 'NewUser' WHEN u.Reputation BETWEEN 100 AND 499 THEN 'LowerRepUser' ELSE 'HigherRepUser' END as RepCategory, 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 LEFT JOIN Users u ON u.Id = se.OwnerUserId WHERE se.RejectionDate is NULL AND se.ApprovalDate is NULL -- AND (p.PostTypeId = 1 OR p.PostTypeId = 2) GROUP BY p.PostTypeId, u.Reputation -- ORDER BY TagOnlyEdits DESC