Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

select t.TagName,
count(case when p.CreationDate between '2007-1-1' and '2020-7-1' then 1 else null end) as Total
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId
and t.TagName in ('abap','actionscript','ada','ampl','apex','apiblueprint','arduino','asp-classic','assembly','bitbake','c','c#','c++','chapel','clojure','coffeescript','coldfusion','common-lisp','coq','crystal-lang','css','cuda','d','dart','elisp','elixir','elm','erlang','f#','fortran','freemarker','game-maker-language','gap-system','gcc','gdscript','gherkin','glsl','gnuplot','go','gosu','groovy','hacklang','haskell','haxe','hcl','java','javascript','jsonnet','julia','kotlin','lean','liquid','livescript','logos','looker','lua','m4','matlab','maxscript','modelica','nim-lang','nimrod','nix','nsis','objective-c','objective-c++','ocaml','owl','pascal','pawn','perl','php','postscript','powershell','processing','prolog','protocol-buffers','puppet','purescript','python','qml','r','racket','raku','raml','reason','renpy','robotframework','ruby','rust','salt-stack','sas','scala','scheme','shaderlab','shell','smalltalk','smarty','sml','solidity','sqf','starlark','swift','system-verilog','tcl','typescript','vala','vb.net','verilog','vhdl','viml','webassembly','wolfram-mathematica','xquery','xtend')
group by t.TagName

Enter Parameters

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