SELECT p.PostTypeId, count(*) AS NumPosts, CASE WHEN u.Re...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess Meta

Q&A about the site for serious players and enthusiasts of chess

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results