1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

; with counts_cte AS (
SELECT 
  eomonth(q.CreationDate) AS Cmonth,
  SUM(COUNT(q.Id)) OVER (ORDER BY eomonth(q.CreationDate)) AS countall,
  SUM(SUM(case when 
  ((q.PostTypeId = 1)
  AND NOT(q.Tags LIKE '%<ag.algebraic-geometry>%')
  AND NOT(q.Tags LIKE '%<nt.number-theory>%')
  AND NOT(q.Tags LIKE '%<co.combinatorics>%')
  AND NOT(q.Tags LIKE '%<at.algebraic-topology>%')
  AND NOT(q.Tags LIKE '%<gr.group-theory>%')
  AND NOT(q.Tags LIKE '%<dg.differential-geometry>%')
  AND NOT(q.Tags LIKE '%<pr.probability>%')
  AND NOT(q.Tags LIKE '%<rt.representation-theory>%')
  AND NOT(q.Tags LIKE '%<ct.category-theory>%')
  AND NOT(q.Tags LIKE '%<fa.functional-analysis>%')
  AND NOT(q.Tags LIKE '%<ac.commutative-algebra>%')
  AND NOT(q.Tags LIKE '%<lo.logic>%')
  AND NOT(q.Tags LIKE '%<gt.geometric-topology>%')
  AND NOT(q.Tags LIKE '%<ca.classical-analysis-and-odes>%')
  AND NOT(q.Tags LIKE '%<gn.general-topology>%')
  AND NOT(q.Tags LIKE '%<ra.rings-and-algebras>%')
  AND NOT(q.Tags LIKE '%<mg.metric-geometry>%')
  AND NOT(q.Tags LIKE '%<ap.analysis-of-pdes>%')
  AND NOT(q.Tags LIKE '%<mp.mathematical-physics>%')
  AND NOT(q.Tags LIKE '%<st.statistics>%')
  AND NOT(q.Tags LIKE '%<ds.dynamical-systems>%')
  AND NOT(q.Tags LIKE '%<cv.complex-variables>%')
  AND NOT(q.Tags LIKE '%<ho.history-overview>%')
  AND NOT(q.Tags LIKE '%<oa.operator-algebras>%')
  AND NOT(q.Tags LIKE '%<na.numerical-analysis>%')
  AND NOT(q.Tags LIKE '%<sg.symplectic-geometry>%')
  AND NOT(q.Tags LIKE '%<oc.optimization-and-control>%')
  AND NOT(q.Tags LIKE '%<qa.quantum-algebra>%')
  AND NOT(q.Tags LIKE '%<kt.k-theory-and-homology>%')
  AND NOT(q.Tags LIKE '%<sp.spectral-theory>%')
  AND NOT(q.Tags LIKE '%<it.information-theory>%')
  AND NOT(q.Tags LIKE '%<gm.general-mathematics>%'))
  then 1 else 0 end)) OVER (ORDER BY eomonth(q.CreationDate)) AS countnotl
FROM Posts q
WHERE (q.PostTypeId=1)
GROUP BY eomonth(q.CreationDate)
)

SELECT 
  Cmonth,
  ROUND((CAST(countnotl AS decimal))*100.0/(CAST(countall AS decimal)),3) AS percentage
FROM counts_cte
ORDER BY Cmonth

fork query

created jan 14 Martin20528