with all_count as( select year(CreationDate) as all_year,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

with all_count as(
select year(CreationDate) as all_year, 
SUM(CASE WHEN 1=1 THEN 1 ELSE 0 END) as all_c
from Posts
where PostTypeId=1
group by year(CreationDate)
), 
kotlin_count as (
select year(CreationDate) as kot_year, 
SUM(CASE WHEN lower(Tags) like '%kotlin%' THEN 1 ELSE 0 END) as kot_c
from Posts
where PostTypeId=1
group by year(CreationDate)

)

select *, kot_c+all_c as procent
from all_count
join kotlin_count on all_count.all_year=kotlin_count.kot_year
order by all_count.all_year

Enter Parameters

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