VCSs popularity on Stack Overflow based on number of questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Tezos

Q&A for users, experts, and developers of the Tezos blockchain project

SELECT 
    t1.Year, 
    t1.[git], 
    COALESCE(t2.[SVN], 0) AS [SVN], 
    COALESCE(t3.[Mercurial], 0) AS [Mercurial],
    COALESCE(t4.[CVS], 0) AS [CVS]
FROM (
Select 
    Year(Posts.CreationDate) as Year, 
    Count(*) As git
From 
    Posts 
Where 
    PostTypeId = 1 And 
    Tags Like '%<git%>%' And 
    Posts.CreationDate >= '2009-01-01' And
    Posts.CreationDate < '2020-01-01'
    
Group By
    Year(Posts.CreationDate)
) t1
INNER JOIN (
Select 
    Year(Posts.CreationDate) as Year, 
    Count(*) As SVN
From 
    Posts 
Where 
    PostTypeId = 1 And 
    (Tags Like '%<svn%>%' OR Tags Like '%<subversion%>%') And 
    Posts.CreationDate >= '2009-01-01' And
    Posts.CreationDate < '2020-01-01'
    
Group By
    Year(Posts.CreationDate)
) t2
ON (t1.Year = t2.Year)
INNER JOIN (
Select 
    Year(Posts.CreationDate) as Year, 
    Count(*) As Mercurial
From 
    Posts 
Where 
    PostTypeId = 1 And 
    (Tags Like '%<mercurial%>%' OR Tags Like '%<hg%>%') And 
    Posts.CreationDate >= '2009-01-01' And
    Posts.CreationDate < '2020-01-01'
    
Group By
    Year(Posts.CreationDate)
) t3
ON (t2.Year = t3.Year)
INNER JOIN (
Select 
    Year(Posts.CreationDate) as Year, 
    Count(*) As CVS
From 
    Posts 
Where 
    PostTypeId = 1 And 
    Tags Like '%<cvs%>%' And 
    Posts.CreationDate >= '2009-01-01' And
    Posts.CreationDate < '2020-01-01'
    
Group By
    Year(Posts.CreationDate)
) t4
ON (t2.Year = t4.Year)
ORDER BY Year

Enter Parameters

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