AVG Vs Std Cost with Inv from As of

SELECT t1.C2ctry, t1.C2fy, t1.C2itm, t1.C2litm, t1.C2mcu, t3.c0mmcu, t1.C2ledg, t2.Coledg,  t1.C2uncs/10000, t2.Councs/10000 ,t4.inlocn, t4.inlotn, t4.inglpt, t4.innq09/1000 FROM proddta.F554105 t1, proddta.F4105 t2, proddta.F554103 t3, proddta.F41112 t4
WHERE
t1.c2ledg = '02' AND
t2.coledg = '07' AND
t1.c2itm = t2.coitm AND
t1.c2mcu = t2.comcu AND
t1.c2pn = 9 AND
t2.coitm = t4.initm AND
t2.comcu = t4.inmcu AND
t4.innq09 <> 0 AND
--t2.c2pn  = 8 AND
--t1.c2uncs <> t2.c2uncs AND
t1.c2mcu = '     3110022' AND
t1.c2mcu = t3.c0mcu
ORDER BY t1.C2ctry, t1.C2fy, t1.C2itm, t1.C2litm, t3.C0mmcu, t1.c2mcu;