PostnoticeTypeId by frequency

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
  PostNoticeTypeId,
  COUNT(Id) AS [Count],
  CASE PostNoticeTypeId
    WHEN 1 THEN 'Citation needed'
    WHEN 2 THEN 'Current event'
    WHEN 3 THEN 'Insufficient explanation'
    WHEN 10 THEN 'Current answers are outdated'
    WHEN 11 THEN 'Draw attention'
    WHEN 12 THEN 'Improve details'
    WHEN 13 THEN 'Authoritative reference needed'
    WHEN 14 THEN 'Canonical answer required'
    WHEN 15 THEN 'Reward existing answer'
    WHEN 20 THEN 'Content dispute'
    WHEN 21 THEN 'Offtopic comments'
    WHEN 22 THEN 'Historical significance'
    WHEN 23 THEN 'Wiki Answer'    
  END    
FROM PostNotices
GROUP BY PostNoticeTypeId
ORDER BY COUNT(Id) DESC

Enter Parameters

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