select month(o), sum(case when floor(dewey/1)*1 ='782' then 1 else 0 end)as '782',sum(case when floor(dewey/1)*1 ='741' then 1 else 0 end)as '741',sum(case when floor(dewey/1)*1 ='641' then 1 else 0 end)as '641',sum(case when floor(dewey/1)*1 ='613' then 1 else 0 end)as '613',sum(case when floor(dewey/1)*1 ='917' then 1 else 0 end)as '917',sum(case when floor(dewey/1)*1 ='973' then 1 else 0 end)as '973',sum(case when floor(dewey/1)*1 ='306' then 1 else 0 end)as '306',sum(case when floor(dewey/1)*1 ='398' then 1 else 0 end)as '398',sum(case when floor(dewey/1)*1 ='599' then 1 else 0 end)as '599',sum(case when floor(dewey/1)*1 ='551' then 1 else 0 end)as '551',sum(case when floor(dewey/1)*1 ='811' then 1 else 0 end)as '811',sum(case when floor(dewey/1)*1 ='895' then 1 else 0 end)as '895',sum(case when floor(dewey/1)*1 ='158' then 1 else 0 end)as '158',sum(case when floor(dewey/1)*1 ='155' then 1 else 0 end)as '155',sum(case when floor(dewey/1)*1 ='294' then 1 else 0 end)as '294',sum(case when floor(dewey/1)*1 ='248' then 1 else 0 end)as '248',sum(case when floor(dewey/1)*1 ='428' then 1 else 0 end)as '428',sum(case when floor(dewey/1)*1 ='468' then 1 else 0 end)as '468',sum(case when floor(dewey/1)*1 ='70' then 1 else 0 end)as '70',sum(case when floor(dewey/1)*1 ='31' then 1 else 0 end)as '31' from activity, dewey where year(o)>2010 and year(o)<2012  and activity.bib=dewey.bib group by month(o);
1,75053,26861,11597,6132,2946,3096,2567,4952,2052,1450,2102,1993,1935,1105,1320,606,1512,733,407,309,
2,67821,25358,10193,5557,2713,2745,2495,4578,1778,1269,1892,1811,1678,979,1305,482,1390,688,390,244,
3,76241,29825,11749,6375,3374,3045,2922,4913,2071,1655,2195,2122,1830,1136,1488,606,1511,712,403,264,
4,71796,28716,10617,5690,3260,2711,2630,4517,1809,1295,3111,1955,1736,1012,1255,567,1379,644,357,246,
5,66871,28229,10299,5468,3030,2459,2671,4179,1881,1227,1961,1899,1728,1030,1232,513,1306,575,335,247,
6,68705,32053,10511,5619,3422,2483,2837,4774,1838,1210,1736,1936,1834,1081,1240,566,1412,675,351,308,
7,65450,33514,10390,5176,3265,2476,2590,4617,1832,1145,1788,2038,1777,1043,1138,585,1368,635,315,272,
8,63402,32148,10091,5310,3345,2222,2499,3731,1596,1019,1513,2176,1680,1061,1166,536,1216,562,328,229,
9,52831,24808,8482,4074,2249,2066,2075,3501,1308,943,1547,1771,1373,850,1012,463,1170,554,271,192,
10,66200,28768,11011,5163,2318,2615,2517,4618,1722,1283,1841,1713,1733,1026,1220,502,1447,696,373,328,
11,64146,27033,10688,4807,1960,2722,2282,4482,1708,1223,2035,1758,1572,999,1220,512,1273,599,355,266,
12,63850,26401,10130,4685,1978,2415,2134,3652,1357,1103,1754,1684,1562,1017,1149,509,1299,481,337,267,
