数据显示处理,该怎么处理

时间段            机种            数量
        
2012-02-08 08    ETC56-542N    43
2012-02-08 09    ETC56-542N    37
2012-02-08 10    ETC54-623N    16
2012-02-08 10    ETC54-628N    22
                

时间段            ETC56-542N      ETC54-623N     ETC54-628N    数量合计
                
08:00:00-09:00:00    43                    43
09:00:00-10:00:00    37                    37
10:00:00-11:00:00            16          22        38

SELECT DATE_FORMAT(`date`,'%Y-%m-%d %H') as time,type,count(*) as count FROM `barcode_2d` WHERE date >= '".$thisday2." 08:00:00' AND date < '".$thisday." 08:00:00' GROUP BY type , time ORDER BY date ASC