Poor quality titles per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Year(CreationDate), Month(CreationDate) as [Month],  count(*) as [Count]
from Posts 
where Title not like '%Who%'
AND Title not like '%What%'
AND Title not like '%When%'
AND Title not like '%Where%'
AND Title not like '%Why%'
AND Title not like '%How%'
AND Title not like '%Can%'
AND Title not like '%Is%'
AND Title not like '%Which%'
AND Title not like '%Was%'
AND Title not like '%Are%'
AND Title not like '%Has%'
AND Title not like '%Will%'
AND Title not like '%Do%'
AND Title not like '%?%'
AND ClosedDate is null 

group by year(creationdate), month(CreationDate)

Enter Parameters

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