select g.prod,sum(g.phy_qty) from goods g,sorder s,sorder_prod sp where s.sorder=g.sorder and s.sorder=sp.sorder and g.prod=sp.prod AND S.FINAL_CUST='MTC-HZ' and s.status='COM' and s.comp_date between to_date ('01-01-2006 00:00:00','DD-MM-RRRR HH24:MI:SS') AND to_date ('31-12-2007 23:59:59','DD-MM-RRRR HH24:MI:SS') group up g.prod,sum(g.phy_qty)