Programming languages trends (python as a single language)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select * from 
  ( 
  select year(p.creationDate) as y, count(DISTINCT p.id) as Python 
  from posts p 
  join PostTags pTags on pTags.postId = p.id
  join Tags t on t.id = pTags.tagId
  -- where p.answerCount + p.commentCount > 0 
  where t.tagName in ('python', 'python-3.x', 'python-2.7') 
  AND p.PostTypeId = 1 -- question
  group by year(p.creationDate)
  ) as python 
join 
  ( 
   select year(p.creationDate) as y, 
   count(DISTINCT p.id) as total, 
   sum(case when t.tagName = 'php' then 1 else 0 end)  as PHP , 
   -- count(DISTINCT case when t.tagName in ('python', 'python-3.x', 'python-2.7') then p.id else null end)  as python, 
   sum(case when t.tagName = 'java' then 1 else 0 end)  as Java, 
   sum(case when t.tagName = 'javascript' then 1 else 0 end)  as JavaScript,     
   sum(case when t.tagName = 'c++' then 1 else 0 end)  as 'C++',
   sum(case when t.tagName = 'swift' then 1 else 0 end)  as Swift,
   sum(case when t.tagName = 'c#' then 1 else 0 end)  as 'C#',
   sum(case when t.tagName = 'sql' then 1 else 0 end)  as SQL,
   sum(case when t.tagName = 'r' then 1 else 0 end)  as R, 
   sum(case when t.tagName = 'c' then 1 else 0 end)  as C, 
   sum(case when t.tagName = 'objective-c' then 1 else 0 end)  as 'Objective-C',
   sum(case when t.tagName = 'ruby' then 1 else 0 end)  as Ruby,
   sum(case when t.tagName = 'vba' then 1 else 0 end)  as VBA, 
   sum(case when t.tagName = 'go' then 1 else 0 end)  as Go, 
   sum(case when t.tagName = 'rust' then 1 else 0 end)  as Rust, 
   sum(case when t.tagName = 'elixir' then 1 else 0 end)  as Elixir     

  from posts p 
  join PostTags pTags on pTags.postId = p.id
  join Tags t on t.id = pTags.tagId
  where  p.PostTypeId = 1 -- question
  -- where p.answerCount + p.commentCount > 0 
  group by year(p.creationDate)
  ) as other_languages on  other_languages.y = python.y 
  
order by python.y

Enter Parameters

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