Popular programming languages per over time

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

select dateadd(month, datediff(month, 0, q.CreationDate), 0) m, TagName, count(*)
from PostTags pt
join Posts q on q.Id=pt.PostId
join Tags t on t.Id=pt.TagId
where TagName in ('flutter', 'java','c','c++','python','c#', 'f#', 'Xamarin', 'PowerShell', 'Perl',  'Go',  'erlang', 'Common Lisp', 'OCaml', 'Julia', 'Elixir', 'CoffeeScript', 'Clojure', 'Haskell', 'Scala', 'TypeScript', 'Erlang', 'Elm', 'javascript','assembly','php','perl','ruby','groovy', 'WebAssembly', 'Pascal', 'visual basic', 'r','object-c','scratch','go','swift','delphi')
and q.CreationDate < dateadd(month, datediff(month, 0, getdate()), 0)
group by dateadd(month, datediff(month, 0, q.CreationDate), 0), TagName
order by dateadd(month, datediff(month, 0, q.CreationDate), 0)

Enter Parameters

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