SELECT year(cout) as Years, month(cout) as Months, cout as Dates, itemtype,SUM(case When subj like '%chinese%' and subj like '%food%' Then 1 Else 0 End) as chinese,SUM(case When subj like '%vegetarian%' and subj like '%food%' Then 1 Else 0 End) as vegetarian,SUM(case When subj like '%spanish%' and subj like '%food%' Then 1 Else 0 End) as spanish,SUM(case When subj like '%Italian%' and subj like '%food%' Then 1 Else 0 End) as italian,SUM(case When subj like '%french%' and subj like '%food%' Then 1 Else 0 End) as french,SUM(case When subj like '%dessert%' and subj like '%food%' Then 1 Else 0 End) as dessert FROM inraw where year(cout)= ('2007') or year(cout)= ('2008') or year(cout)= ('2009') or year(cout)= ('2010') or year(cout)= ('2011') or year(cout)=('2012') GROUP BY month(cout), year(cout);
2007,1,2007-01-02 09:20:00.0,accd,16,65,7,89,23,4
2008,1,2008-01-02 08:54:00.0,acbk,34,108,31,87,43,18
2009,1,2009-01-02 08:14:00.0,acbk,132,152,46,88,69,32
2010,1,2010-01-02 10:02:00.0,acbk,104,204,33,206,70,55
2011,1,2011-01-02 09:44:00.0,acbk,54,276,32,87,108,37
2007,2,2007-02-02 13:04:00.0,acdvd,21,76,13,94,15,5
2008,2,2008-02-01 09:05:00.0,acbk,22,100,19,56,21,12
2009,2,2009-02-01 11:50:00.0,acbk,86,179,25,53,38,35
2010,2,2010-02-01 08:13:00.0,jcbk,72,206,34,143,77,32
2011,2,2011-02-01 10:06:00.0,acbk,62,247,23,82,89,19
2007,3,2007-03-01 08:17:00.0,jcbk,15,103,12,115,29,2
2008,3,2008-03-01 09:35:00.0,acbk,57,98,18,99,46,10
2009,3,2009-03-01 10:58:00.0,acdvd,69,165,49,71,58,28
2010,3,2010-03-01 09:00:00.0,acbk,71,236,37,171,111,64
2011,3,2011-03-01 09:46:00.0,jcbk,50,310,57,109,99,43
2007,4,2007-04-01 10:54:00.0,acbk,12,88,8,102,27,5
2008,4,2008-04-01 08:19:00.0,acbk,110,122,13,60,21,8
2009,4,2009-04-01 08:59:00.0,accas,61,195,47,82,31,46
2010,4,2010-04-01 08:34:00.0,acdvd,62,317,25,115,124,62
2011,4,2011-04-01 08:23:00.0,acbk,48,277,63,64,78,48
2007,5,2007-05-01 08:55:00.0,acbk,2,74,12,60,21,0
2008,5,2008-05-01 08:29:00.0,acdvd,117,107,24,48,27,14
2009,5,2009-05-01 10:05:00.0,acdvd,58,155,65,118,29,41
2010,5,2010-05-01 10:18:00.0,acbk,67,268,43,106,98,56
2011,5,2011-05-01 12:29:00.0,acbk,32,270,23,64,109,28
2007,6,2007-06-02 16:03:00.0,acbk,13,91,14,74,28,7
2008,6,2008-06-01 11:41:00.0,acbk,125,75,11,53,35,4
2009,6,2009-06-01 07:46:00.0,acbk,63,188,70,101,38,47
2010,6,2010-06-01 09:20:00.0,dcillb,50,322,29,113,123,49
2011,6,2011-06-01 09:41:00.0,jcbk,39,260,33,60,69,42
2007,7,2007-07-01 12:08:00.0,acbk,8,88,9,94,4,15
2008,7,2008-07-01 10:07:00.0,jcdvd,114,119,23,62,30,14
2009,7,2009-07-01 09:33:00.0,acbk,63,154,41,159,34,49
2010,7,2010-07-01 08:42:00.0,acdvd,56,270,39,107,107,51
2011,7,2011-07-01 09:51:00.0,accd,35,242,24,54,86,25
2007,8,2007-08-01 07:32:00.0,acbk,10,72,10,73,17,12
2008,8,2008-08-01 09:50:00.0,acdvd,125,121,12,55,37,10
2009,8,2009-08-01 09:51:00.0,accd,72,182,46,114,64,43
2010,8,2010-08-01 10:00:00.0,acbk,55,248,32,114,91,34
2011,8,2011-08-01 10:19:00.0,accd,23,126,19,58,41,22
2007,9,2007-09-01 09:26:00.0,acbk,6,73,3,61,33,3
2008,9,2008-09-02 08:37:00.0,acdvd,151,157,21,42,31,5
2009,9,2009-09-08 08:40:00.0,jcbk,50,117,39,132,36,35
2010,9,2010-09-07 08:36:00.0,acdvd,59,173,23,84,88,21
2011,9,2011-09-01 08:34:00.0,jcdvd,21,103,19,30,24,15
2007,10,2007-10-01 08:36:00.0,jcbk,10,86,6,48,41,14
2008,10,2008-10-01 08:25:00.0,acbk,130,151,22,56,34,13
2009,10,2009-10-01 07:59:00.0,jcbk,57,183,51,209,62,44
2010,10,2010-10-01 10:24:00.0,acbk,37,226,33,64,91,40
2011,10,2011-10-01 10:20:00.0,acbk,21,111,24,45,25,20
2007,11,2007-11-01 09:44:00.0,jcbk,18,96,20,65,44,6
2008,11,2008-11-01 09:50:00.0,acbk,118,136,44,33,34,7
2009,11,2009-11-01 09:22:00.0,acbk,52,181,37,198,44,49
2010,11,2010-11-01 09:04:00.0,acdvd,27,230,37,61,92,31
2011,11,2011-11-01 09:52:00.0,acbk,25,95,28,36,46,16
2007,12,2007-12-01 09:28:00.0,jcdvd,15,114,9,56,37,7
2008,12,2008-12-01 08:52:00.0,acdvd,129,125,36,61,40,21
2009,12,2009-12-01 09:38:00.0,jcdvd,73,179,26,184,77,54
2010,12,2010-12-01 10:00:00.0,acbk,64,255,23,58,82,24
2011,12,2011-12-01 10:09:00.0,acdvd,9,37,6,24,20,5
