arXiv tag answer stats

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  Tags.TagName,
  COUNT(*) AS Count,
  AVG(CAST(PostsA.Score AS FLOAT)) AS AvgScore,
  AVG(LEN(PostsA.Body)) AS AvgLenBody,
  AVG(Users.Reputation) AS AvgPosterReputation,
  AVG(CAST(PostsA.CommentCount AS FLOAT)) AS AvgCommentCount
  
FROM Tags
  LEFT JOIN PostTags ON PostTags.TagId = Tags.Id
  LEFT JOIN Posts ON Posts.Id = PostTags.PostId
  LEFT JOIN Posts PostsA ON PostsA.ParentId = Posts.Id
  LEFT JOIN PostTypes ON PostTypes.Id = PostsA.PostTypeId
  LEFT JOIN Users ON PostsA.OwnerUserId = Users.Id

WHERE
 Tags.TagName IN (
    'ag.algebraic-geometry',
    'nt.number-theory',
    'co.combinatorics',
    'at.algebraic-topology',
    'gr.group-theory',
    'dg.differential-geometry',
    'pr.probability',
    'fa.functional-analysis',
    'rt.representation-theory',
    'ct.category-theory',
    'ac.commutative-algebra',
    'lo.logic',
    'gt.geometric-topology',
    'gn.general-topology',
    'ca.analysis-and-odes',
    'mg.metric-geometry',
    'ra.rings-and-algebras',
    'ap.analysis-of-pdes',
    'cv.complex-variables',
    'mp.mathematical-physics',
    'ds.dynamical-systems',
    'st.statistics',
    'oa.operator-algebras',
    'ho.history-overview',
    'na.numerical-analysis',
    'sg.symplectic-geometry',
    'oc.optimization-control',
    'qa.quantum-algebra',
    'kt.k-theory-homology',
    'sp.spectral-theory',
    'it.information-theory',
    'gm.general-mathematics'

  ) AND
  
  PostTypes.Name = 'Answer'

GROUP BY
  Tags.TagName

ORDER BY
  Tags.TagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results