Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

select t.TagName,
count(case when p.CreationDate between '2007-1-1' and '2024-1-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 ('javascript','typescript','python','java','ruby','php','go','css','c#','c++','shell','c','rust','kotlin','scala','swift','-','hcl','dart','powershell','objective-c','r','julia','elixir','lua','nix','groovy','perl','haskell','smarty','clojure','coffeescript','ocaml','solidity','viml','elisp','astrojs','erlang','matlab','fortran','starlark','shaderlab','f#','assembly','elm','gdscript','apex','puppet','d','-','gherkin','stylus','nim-lang','crystal-lang','hacklang','liquid','verilog','tcl','common-lisp','smalltalk','ballerina','pascal','vb.net','qml','system-verilog','lean','jsonnet','haxe','bitbake','purescript','wolfram-mathematica','vala','azure-bicep','glsl','processing','sqf','scheme','zig','reason','cuda','salt-stack','coq','vhdl','asp-classic','raku','arduino','sass','nextflow','racket','vba','brainfuck','objective-c++','chapel','modelica','coldfusion','webassembly','freemarker','gap-system','vb.net','postscript','gcc','vlang','renpy','abap','actionscript','robotframework','pawn')
group by t.TagName

Enter Parameters

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