sql
SELECT LEFT( time, 4 ), sum( column ) FROM yourTableName GROUP BY type, LEFT ( time, 4 )
SELECT LEFT( time, 4 ), sum( column ) FROM yourTableName GROUP BY type, LEFT ( time, 4 )