Percentage of questions with keyword in the title

Please login or register to vote for this query.

(click on this box to dismiss)

$Mathematics$

Q&A for people studying math at any level and professionals in related fields

select round(100*(sum(case when lower(Title) like '%##keyword##%' then 1 else 0 end)+0.1)/count(Id),2) from Posts
where PostTypeId = 1

edited jul 26 14

created jul 26 14

jon.doe14699

Options: Text-only results Include execution plan

Switch to meta site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached