html queries by year

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 year(creationDate), 

sum(case when Tags LIKE '%python%' then 1.0 else 0.0 end) / count(Id) as python,
sum(case when Tags LIKE '%javascript%' then 1.0 else 0.0 end) / count(Id) as js, 
sum(case when Tags LIKE '%.net%' then 1.0 else 0.0 end) / count(Id) as net, 
sum(case when Tags LIKE '%java%' then 1.0 else 0.0 end) / count(Id) as java 


FROM Posts 
-- where Tags LIKE '%python%' or Tags like '%javascript%'
group by year(CreationDate)

Enter Parameters

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