What % of Python questions have the word “pythonic” in them?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/q/367687/578411

Stack Overflow

Q&A for professional and enthusiast programmers

select cnt [all python]
     , title
     , body
     , cast(title as decimal) / cnt * 100 as [% title]
     , cast(body as decimal) / cnt  * 100 as [% body]
     , (cast(body as decimal) + cast(title as decimal))  / cnt  * 100 as tot
from 
(
select count(*) as cnt
     , sum(
       case 
       when title like '%pythonic%' collate sql_latin1_general_cp1_ci_ai 
       then 1
       else 0
       end
       ) title
     , sum(
       case 
       when body like '%pythonic%' collate sql_latin1_general_cp1_ci_ai 
       then 1
       else 0
       end
       ) body
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where p.posttypeid = 1
and t.tagname ='python'
) data

Enter Parameters

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