arXiv tag question 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(Posts.Score AS FLOAT)) AS AvgScore,
  AVG(Posts.ViewCount) AS AvgViewCount,
  AVG(CAST(LEN(Posts.Title) AS FLOAT)) AS AvgLenTitle,
  AVG(LEN(Posts.Body)) AS AvgLenBody,
  AVG(Users.Reputation) AS AvgPosterReputation,
  AVG(CAST(Posts.CommentCount AS FLOAT)) AS AvgCommentCount,
  AVG(CAST(Posts.FavoriteCount AS FLOAT)) AS AvgFavoriteCount,
  AVG(CAST(Posts.AnswerCount AS FLOAT)) AS AvgAnswerCount,
  Count(Posts.ClosedDate) AS Closed,
  CAST(100 * Count(Posts.ClosedDate) AS FLOAT)/Count(*) AS PercentClosed
  
FROM Tags
  LEFT JOIN PostTags ON PostTags.TagId = Tags.Id
  LEFT JOIN Posts ON Posts.Id = PostTags.PostId
  LEFT JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId
  LEFT JOIN Users ON Posts.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 = 'Question'

GROUP BY
  Tags.TagName

ORDER BY
  Tags.TagName

Enter Parameters

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