Analyse posts by standard tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Quantitative Finance Meta

Q&A about the site for finance professionals and academics

SELECT top (100)
  q.Id as PostId, 
  q.PostTypeId,
  q.CreationDate as Created, 
  q.Score as Score, 
  q.Body as Description, 
  q.CommentCount as Comments,
  CASE 
    WHEN q.Body LIKE '%/questions/tagged/bug%' THEN 'bug' 
    WHEN q.Body LIKE '%/questions/tagged/support%' THEN 'support' 
    WHEN q.Body LIKE '%/questions/tagged/discussion%' THEN 'discussion' 
    WHEN q.Body LIKE '%/questions/tagged/feature-request%' THEN 'feature-request' 
    ELSE 'no tag'
  END as Tag,
  CASE 
    WHEN q.Body LIKE '%/questions/tagged/status-completed%' THEN 'status-completed' 
    WHEN q.Body LIKE '%/questions/tagged/status-declined%' THEN 'status-declined' 
    WHEN q.Body LIKE '%/questions/tagged/status-review%' THEN 'status-review' 
    WHEN q.Body LIKE '%/questions/tagged/status-bydesign%' THEN 'status-bydesign' 
    ELSE 'no status'
  END as Status
FROM Posts q
ORDER BY q.CreationDate

Enter Parameters

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