Q&A for users, experts, and developers of the Tezos blockchain project
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)