Second

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select year(creationdate), cast(count(case when tags like '%<kotlin>%' then 1 end) as float)*100/count(*) as per
from posts
where posttypeid=1
group by year(creationdate)
order by year(creationdate)

Enter Parameters

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