select month(i), 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(i)>2010 and year(i)<2012  and activity.bib=dewey.bib group by month(i);
1,63317,22230,9539,4759,2146,2410,2140,3147,1378,1039,1603,1641,1550,940,1074,512,1064,507,351,209,
2,59616,20730,8918,4905,2214,2341,2120,3341,1361,1092,1544,1332,1445,860,1148,441,1012,513,331,209,
3,67176,24468,9843,5312,2642,2693,2583,4022,1724,1263,1743,1678,1607,951,1233,537,1271,575,330,188,
4,63238,24482,9446,5145,2716,2314,2347,3587,1440,1203,2193,1681,1599,950,1175,474,1153,500,325,193,
5,60133,23725,8962,4780,2665,2121,2309,3278,1496,1033,1891,1475,1563,897,1147,508,1055,516,304,170,
6,61058,25529,8894,4692,2727,2078,2449,3622,1591,1001,1741,1556,1514,913,1100,465,1106,494,282,233,
7,56682,27116,8543,4477,2711,2049,2197,3403,1323,893,1379,1605,1505,886,969,507,1095,428,270,236,
8,53980,26394,7965,4192,2526,1764,2052,2945,1289,861,1310,1527,1397,851,887,434,892,422,261,178,
9,39601,18718,6233,3078,1861,1516,1591,2315,977,638,1005,1423,1056,702,738,332,907,328,224,136,
10,48305,21259,7800,3667,1963,1844,1748,3099,1194,895,1310,1330,1230,739,874,373,1108,521,256,206,
11,48216,20009,7596,3431,1470,1919,1705,3325,1213,910,1440,1246,1160,696,806,422,962,426,248,184,
12,50102,20254,8031,3426,1454,2021,1678,3085,1164,894,1476,1274,1194,772,961,369,1036,373,260,210,
