SELECT
MONTH(cout),
MONTH(cout),
YEAR(cout),
SUM(CASE
WHEN title LIKE '%autobiography' THEN 1
ELSE 0
END) AS autobio
FROM
spl2.inraw
WHERE
DATE(cout) >= '2006-01-01'
AND DATE(cout) <= '2013-12-31'
GROUP BY MONTH(cout) , YEAR(cout)
ORDER BY YEAR(cout) , MONTH(cout)
General view of the grid. 2008 and 2010 were the years with most interest. 2006 show very small interest, but this can be because of partial data logs.
Query time: 320s.