sqlite> SELECT strftime('%Y/%m', date) AS date, SUM(CASE WHEN content like '%Michael Jackson%' THEN 1 ELSE 0 END) AS count FROM articles GROUP BY date ORDER BY date DESC;
date|count
2009/07|54
2009/06|94
2009/05|3
2009/04|1
2009/03|0
2009/02|1
2009/01|0
2008/12|1
2008/11|4
2008/10|0
2008/09|0
2008/08|1
2008/07|0
2008/06|0
2008/05|0
2008/04|0
2008/03|0
2008/02|0
2008/01|0
2007/12|0
2007/11|2
2007/10|0
2007/09|0
2007/08|0
2007/07|2
2007/06|1
2007/05|0
2007/04|0
2007/03|0
2007/02|1
2007/01|1