select hour(cout) as hour, SUM(CASE WHEN 000 < deweyClass and deweyClass < 010 THEN 1 ELSE 0 END) as '000-010', SUM(CASE WHEN 010 < deweyClass and deweyClass < 020 THEN 1 ELSE 0 END) as '010-020', SUM(CASE WHEN 020 < deweyClass and deweyClass < 030 THEN 1 ELSE 0 END) as '020-030', SUM(CASE WHEN 030 < deweyClass and deweyClass < 040 THEN 1 ELSE 0 END) as '030-040', SUM(CASE WHEN 040 < deweyClass and deweyClass < 050 THEN 1 ELSE 0 END) as '040-050', SUM(CASE WHEN 050 < deweyClass and deweyClass < 060 THEN 1 ELSE 0 END) as '050-060', SUM(CASE WHEN 060 < deweyClass and deweyClass < 070 THEN 1 ELSE 0 END) as '060-070', SUM(CASE WHEN 070 < deweyClass and deweyClass < 080 THEN 1 ELSE 0 END) as '070-080', SUM(CASE WHEN 080 < deweyClass and deweyClass < 090 THEN 1 ELSE 0 END) as '080-090', SUM(CASE WHEN 090 < deweyClass and deweyClass < 100 THEN 1 ELSE 0 END) as '090-100', SUM(CASE WHEN 100 < deweyClass and deweyClass < 110 THEN 1 ELSE 0 END) as '100-110', SUM(CASE WHEN 110 < deweyClass and deweyClass < 120 THEN 1 ELSE 0 END) as '110-120', SUM(CASE WHEN 120 < deweyClass and deweyClass < 130 THEN 1 ELSE 0 END) as '120-130', SUM(CASE WHEN 130 < deweyClass and deweyClass < 140 THEN 1 ELSE 0 END) as '130-140', SUM(CASE WHEN 140 < deweyClass and deweyClass < 150 THEN 1 ELSE 0 END) as '140-150', SUM(CASE WHEN 150 < deweyClass and deweyClass < 160 THEN 1 ELSE 0 END) as '150-160', SUM(CASE WHEN 160 < deweyClass and deweyClass < 170 THEN 1 ELSE 0 END) as '160-170', SUM(CASE WHEN 170 < deweyClass and deweyClass < 180 THEN 1 ELSE 0 END) as '170-180', SUM(CASE WHEN 180 < deweyClass and deweyClass < 190 THEN 1 ELSE 0 END) as '180-190', SUM(CASE WHEN 190 < deweyClass and deweyClass < 200 THEN 1 ELSE 0 END) as '190-200', SUM(CASE WHEN 200 < deweyClass and deweyClass < 210 THEN 1 ELSE 0 END) as '200-210', SUM(CASE WHEN 210 < deweyClass and deweyClass < 220 THEN 1 ELSE 0 END) as '210-220', SUM(CASE WHEN 220 < deweyClass and deweyClass < 230 THEN 1 ELSE 0 END) as '220-230', SUM(CASE WHEN 230 < deweyClass and deweyClass < 240 THEN 1 ELSE 0 END) as '230-240', SUM(CASE WHEN 240 < deweyClass and deweyClass < 250 THEN 1 ELSE 0 END) as '240-250', SUM(CASE WHEN 250 < deweyClass and deweyClass < 260 THEN 1 ELSE 0 END) as '250-260', SUM(CASE WHEN 260 < deweyClass and deweyClass < 270 THEN 1 ELSE 0 END) as '260-270', SUM(CASE WHEN 270 < deweyClass and deweyClass < 280 THEN 1 ELSE 0 END) as '270-280', SUM(CASE WHEN 280 < deweyClass and deweyClass < 290 THEN 1 ELSE 0 END) as '280-290', SUM(CASE WHEN 290 < deweyClass and deweyClass < 300 THEN 1 ELSE 0 END) as '290-300', SUM(CASE WHEN 300 < deweyClass and deweyClass < 310 THEN 1 ELSE 0 END) as '300-310', SUM(CASE WHEN 310 < deweyClass and deweyClass < 320 THEN 1 ELSE 0 END) as '310-320', SUM(CASE WHEN 320 < deweyClass and deweyClass < 330 THEN 1 ELSE 0 END) as '320-330', SUM(CASE WHEN 330 < deweyClass and deweyClass < 340 THEN 1 ELSE 0 END) as '330-340', SUM(CASE WHEN 340 < deweyClass and deweyClass < 350 THEN 1 ELSE 0 END) as '340-350', SUM(CASE WHEN 350 < deweyClass and deweyClass < 360 THEN 1 ELSE 0 END) as '350-360', SUM(CASE WHEN 360 < deweyClass and deweyClass < 370 THEN 1 ELSE 0 END) as '360-370', SUM(CASE WHEN 370 < deweyClass and deweyClass < 380 THEN 1 ELSE 0 END) as '370-380', SUM(CASE WHEN 380 < deweyClass and deweyClass < 390 THEN 1 ELSE 0 END) as '380-390', SUM(CASE WHEN 390 < deweyClass and deweyClass < 400 THEN 1 ELSE 0 END) as '390-400', SUM(CASE WHEN 400 < deweyClass and deweyClass < 410 THEN 1 ELSE 0 END) as '400-410', SUM(CASE WHEN 410 < deweyClass and deweyClass < 420 THEN 1 ELSE 0 END) as '410-420', SUM(CASE WHEN 420 < deweyClass and deweyClass < 430 THEN 1 ELSE 0 END) as '420-430', SUM(CASE WHEN 430 < deweyClass and deweyClass < 440 THEN 1 ELSE 0 END) as '430-440', SUM(CASE WHEN 440 < deweyClass and deweyClass < 450 THEN 1 ELSE 0 END) as '440-450', SUM(CASE WHEN 450 < deweyClass and deweyClass < 460 THEN 1 ELSE 0 END) as '450-460', SUM(CASE WHEN 460 < deweyClass and deweyClass < 470 THEN 1 ELSE 0 END) as '460-470', SUM(CASE WHEN 470 < deweyClass and deweyClass < 480 THEN 1 ELSE 0 END) as '470-480', SUM(CASE WHEN 480 < deweyClass and deweyClass < 490 THEN 1 ELSE 0 END) as '480-490', SUM(CASE WHEN 490 < deweyClass and deweyClass < 500 THEN 1 ELSE 0 END) as '490-500', SUM(CASE WHEN 500 < deweyClass and deweyClass < 510 THEN 1 ELSE 0 END) as '500-510', SUM(CASE WHEN 510 < deweyClass and deweyClass < 520 THEN 1 ELSE 0 END) as '510-520', SUM(CASE WHEN 520 < deweyClass and deweyClass < 530 THEN 1 ELSE 0 END) as '520-530', SUM(CASE WHEN 530 < deweyClass and deweyClass < 540 THEN 1 ELSE 0 END) as '530-540', SUM(CASE WHEN 540 < deweyClass and deweyClass < 550 THEN 1 ELSE 0 END) as '540-550', SUM(CASE WHEN 550 < deweyClass and deweyClass < 560 THEN 1 ELSE 0 END) as '550-560', SUM(CASE WHEN 560 < deweyClass and deweyClass < 570 THEN 1 ELSE 0 END) as '560-570', SUM(CASE WHEN 570 < deweyClass and deweyClass < 580 THEN 1 ELSE 0 END) as '570-580', SUM(CASE WHEN 580 < deweyClass and deweyClass < 590 THEN 1 ELSE 0 END) as '580-590', SUM(CASE WHEN 590 < deweyClass and deweyClass < 600 THEN 1 ELSE 0 END) as '590-600', SUM(CASE WHEN 600 < deweyClass and deweyClass < 610 THEN 1 ELSE 0 END) as '600-610', SUM(CASE WHEN 610 < deweyClass and deweyClass < 620 THEN 1 ELSE 0 END) as '610-620', SUM(CASE WHEN 620 < deweyClass and deweyClass < 630 THEN 1 ELSE 0 END) as '620-630', SUM(CASE WHEN 630 < deweyClass and deweyClass < 640 THEN 1 ELSE 0 END) as '630-640', SUM(CASE WHEN 640 < deweyClass and deweyClass < 650 THEN 1 ELSE 0 END) as '640-650', SUM(CASE WHEN 650 < deweyClass and deweyClass < 660 THEN 1 ELSE 0 END) as '650-660', SUM(CASE WHEN 660 < deweyClass and deweyClass < 670 THEN 1 ELSE 0 END) as '660-670', SUM(CASE WHEN 670 < deweyClass and deweyClass < 680 THEN 1 ELSE 0 END) as '670-680', SUM(CASE WHEN 680 < deweyClass and deweyClass < 690 THEN 1 ELSE 0 END) as '680-690', SUM(CASE WHEN 690 < deweyClass and deweyClass < 700 THEN 1 ELSE 0 END) as '690-700', SUM(CASE WHEN 700 < deweyClass and deweyClass < 710 THEN 1 ELSE 0 END) as '700-710', SUM(CASE WHEN 710 < deweyClass and deweyClass < 720 THEN 1 ELSE 0 END) as '710-720', SUM(CASE WHEN 720 < deweyClass and deweyClass < 730 THEN 1 ELSE 0 END) as '720-730', SUM(CASE WHEN 730 < deweyClass and deweyClass < 740 THEN 1 ELSE 0 END) as '730-740', SUM(CASE WHEN 740 < deweyClass and deweyClass < 750 THEN 1 ELSE 0 END) as '740-750', SUM(CASE WHEN 750 < deweyClass and deweyClass < 760 THEN 1 ELSE 0 END) as '750-760', SUM(CASE WHEN 760 < deweyClass and deweyClass < 770 THEN 1 ELSE 0 END) as '760-770', SUM(CASE WHEN 770 < deweyClass and deweyClass < 780 THEN 1 ELSE 0 END) as '770-780', SUM(CASE WHEN 780 < deweyClass and deweyClass < 790 THEN 1 ELSE 0 END) as '780-790', SUM(CASE WHEN 790 < deweyClass and deweyClass < 800 THEN 1 ELSE 0 END) as '790-800', SUM(CASE WHEN 800 < deweyClass and deweyClass < 810 THEN 1 ELSE 0 END) as '800-810', SUM(CASE WHEN 810 < deweyClass and deweyClass < 820 THEN 1 ELSE 0 END) as '810-820', SUM(CASE WHEN 820 < deweyClass and deweyClass < 830 THEN 1 ELSE 0 END) as '820-830', SUM(CASE WHEN 830 < deweyClass and deweyClass < 840 THEN 1 ELSE 0 END) as '830-840', SUM(CASE WHEN 840 < deweyClass and deweyClass < 850 THEN 1 ELSE 0 END) as '840-850', SUM(CASE WHEN 850 < deweyClass and deweyClass < 860 THEN 1 ELSE 0 END) as '850-860', SUM(CASE WHEN 860 < deweyClass and deweyClass < 870 THEN 1 ELSE 0 END) as '860-870', SUM(CASE WHEN 870 < deweyClass and deweyClass < 880 THEN 1 ELSE 0 END) as '870-880', SUM(CASE WHEN 880 < deweyClass and deweyClass < 890 THEN 1 ELSE 0 END) as '880-890', SUM(CASE WHEN 890 < deweyClass and deweyClass < 900 THEN 1 ELSE 0 END) as '890-900', SUM(CASE WHEN 900 < deweyClass and deweyClass < 910 THEN 1 ELSE 0 END) as '900-910', SUM(CASE WHEN 910 < deweyClass and deweyClass < 920 THEN 1 ELSE 0 END) as '910-920', SUM(CASE WHEN 920 < deweyClass and deweyClass < 930 THEN 1 ELSE 0 END) as '920-930', SUM(CASE WHEN 930 < deweyClass and deweyClass < 940 THEN 1 ELSE 0 END) as '930-940', SUM(CASE WHEN 940 < deweyClass and deweyClass < 950 THEN 1 ELSE 0 END) as '940-950', SUM(CASE WHEN 950 < deweyClass and deweyClass < 960 THEN 1 ELSE 0 END) as '950-960', SUM(CASE WHEN 960 < deweyClass and deweyClass < 970 THEN 1 ELSE 0 END) as '960-970', SUM(CASE WHEN 970 < deweyClass and deweyClass < 980 THEN 1 ELSE 0 END) as '970-980', SUM(CASE WHEN 980 < deweyClass and deweyClass < 990 THEN 1 ELSE 0 END) as '980-990', SUM(CASE WHEN 990 < deweyClass and deweyClass < 999 THEN 1 ELSE 0 END) as '990-999', SUM(CASE WHEN 0 < deweyClass and deweyClass < 1000 THEN 1 ELSE 0 END) as total from inraw where deweyClass < 1000 and cout >= '2011-01-01' and cout <= '2011-01-31' group by hour order by hour
7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,6,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,10
8,0,0,2,1,0,0,0,0,0,0,0,0,0,3,0,5,1,3,0,0,2,0,1,1,1,0,2,0,0,5,8,0,2,14,2,1,10,6,10,47,0,0,10,0,0,0,0,0,0,0,4,1,4,6,0,5,3,8,1,43,0,15,25,62,23,2,1,0,0,0,4,4,1,9,51,7,1,3,219,48,5,17,2,10,0,0,8,0,0,49,0,59,0,8,11,12,0,22,1,0,897
9,0,2,1,1,0,0,0,5,0,0,0,0,0,0,0,20,0,12,0,0,1,3,4,0,0,0,0,0,1,11,27,0,2,14,6,1,15,11,0,33,0,0,5,0,0,0,0,0,0,0,6,6,6,4,0,11,5,7,1,39,0,77,6,21,34,3,0,0,2,0,15,2,1,8,69,15,4,16,217,49,5,35,3,0,5,0,0,0,1,41,10,38,2,4,21,19,4,42,3,2,1040
10,114,4,21,5,0,0,0,29,10,0,1,5,21,40,0,226,0,38,4,13,41,14,21,29,40,5,20,13,15,152,310,0,107,266,51,36,272,141,53,308,3,38,63,15,5,5,33,1,0,18,65,53,82,32,8,62,28,86,23,259,3,737,167,218,844,150,3,9,18,22,49,11,58,57,1058,80,11,48,4108,442,69,282,76,8,33,0,13,0,7,105,59,335,18,65,233,111,25,249,9,10,13238
11,237,4,32,11,0,0,3,36,1,0,2,5,14,116,2,411,2,75,4,6,73,21,40,51,122,3,23,39,38,255,609,0,172,574,82,60,428,217,48,555,5,54,74,11,50,16,83,0,3,54,73,99,89,83,23,118,72,129,30,411,29,1373,345,415,1713,383,11,7,93,53,137,30,110,102,2288,150,16,181,8337,883,117,536,145,7,14,5,25,2,8,207,71,748,37,76,374,215,58,472,35,31,25961
12,322,16,31,30,0,1,2,46,9,0,5,5,47,164,11,569,0,89,2,17,67,31,47,73,113,12,17,45,31,291,760,0,222,650,124,76,554,205,83,559,7,43,166,23,36,17,100,0,0,64,97,100,123,87,10,175,87,148,40,455,8,1728,276,437,2162,420,25,9,73,71,179,66,165,90,3136,211,25,129,10897,1134,151,666,228,10,38,7,47,2,11,226,80,879,39,78,472,272,59,672,39,29,32663
13,495,25,42,23,0,0,4,85,33,0,5,5,46,162,4,887,2,119,13,41,160,38,48,90,159,14,32,37,47,483,1124,0,291,931,177,90,772,388,133,831,4,100,225,35,66,22,96,0,4,94,133,196,195,96,21,205,105,186,56,649,18,2409,443,645,2978,699,38,15,161,112,300,125,217,184,4713,320,27,236,15986,1724,246,917,236,20,43,9,51,3,12,406,109,1308,54,143,657,420,65,965,35,41,47952
14,441,26,51,34,0,1,3,56,18,0,4,12,35,199,3,971,1,153,22,32,172,59,97,73,134,9,40,53,70,489,1136,0,372,966,182,130,862,381,138,953,7,82,201,22,61,28,136,1,0,131,153,173,150,100,50,243,109,227,51,705,27,2379,398,705,2980,684,42,17,107,112,323,103,252,164,5884,282,46,214,16424,1680,254,887,310,27,60,9,64,8,31,363,107,1535,49,167,694,400,77,1015,46,33,50484
15,504,28,52,49,0,2,9,74,23,2,6,4,39,218,1,1019,2,163,30,20,156,43,73,93,133,8,36,42,64,545,1344,0,327,1013,148,133,870,456,107,886,19,71,283,44,68,33,133,5,3,133,174,247,164,145,28,224,141,245,49,857,30,2534,520,799,3198,657,47,15,157,103,281,112,252,181,6813,375,23,226,18224,1943,263,1085,263,27,52,10,64,12,13,469,141,1513,52,205,733,451,113,1013,62,45,55394
16,502,19,70,67,0,1,6,60,21,0,5,31,32,245,7,1061,1,163,12,55,147,49,60,77,162,16,25,28,55,610,1388,0,324,1125,172,130,875,496,152,1155,11,96,311,45,87,42,147,2,7,196,218,222,212,162,60,353,158,284,71,1090,34,2891,520,911,3516,735,56,11,128,138,238,106,234,177,7524,340,37,311,20068,2161,305,1201,236,13,61,17,75,3,20,266,131,1684,99,182,699,489,141,1173,69,46,60835
17,481,26,65,41,0,1,2,55,9,0,6,7,32,185,5,911,0,126,18,23,134,60,65,78,135,10,24,42,35,496,1286,0,315,1124,175,122,762,504,79,835,12,60,259,22,59,22,110,1,1,123,124,216,161,126,36,234,80,193,45,702,28,2579,528,701,3108,778,72,25,121,140,273,76,210,154,6423,288,30,179,18741,1878,258,1013,285,21,39,8,80,3,28,221,107,1467,65,117,538,398,130,878,51,35,53422
18,203,16,26,18,0,0,0,18,6,0,0,3,19,124,0,383,0,32,10,8,50,16,16,26,47,0,11,10,16,181,587,0,135,401,83,37,360,168,53,291,2,25,73,7,19,8,28,1,0,48,51,59,40,45,7,98,28,87,14,283,9,1096,133,264,1213,294,14,7,79,32,116,28,123,67,2345,123,11,113,8180,790,95,401,99,22,6,2,17,1,4,50,57,532,28,44,225,156,35,398,20,11,21714
19,189,4,20,7,0,1,1,41,9,0,0,0,7,68,0,365,0,41,3,10,48,23,22,26,48,1,12,15,6,167,420,0,116,410,63,26,271,165,43,236,0,27,78,12,33,7,36,0,0,50,70,81,91,51,14,111,17,47,24,189,8,937,176,261,1072,233,14,1,39,41,93,32,77,66,1817,90,7,110,6687,663,79,350,102,8,23,2,27,2,4,62,25,467,23,53,168,123,27,332,9,21,18338
20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,3,0,0,0,1,0,2,5,3,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,6,0,3,0,10,0,0,8,3,0,0,1,0,1,0,0,0,17,0,0,0,30,3,0,4,1,0,0,0,0,0,0,0,0,2,0,0,0,2,0,8,0,0,118
21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,4
23,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,4,1,1,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,10
