Q&A for professional and enthusiast programmers
select year(creationdate) as year, cast( count(case when lower(tags) like '%kotlin%' then 1 end) as decimal ) / count(id) * 100 as 'percent' from posts group by year(creationdate)