select prod_id,substr(prod_date,5,2),round(sum(prod_amt)/10000,0) from temp_table group by cube(prod_id,substr(prod_date,5,2));