SELECT SUM(ORDERITEMS.qty*INVENTORY.PRICE) / COUNT(DISTINCT ORDERS.ORDERID) AS 'Orders_Average' AS 'OrderItems_Average' FROM ORDERITEMS LEFT OUTER JOIN INVENTORY ON ORDERITEMS.PARTID = INVENTORY.PARTID RIGHT OUTER JOIN ORDERS ON ORDERITEMS.ORDERID = ORDERS.ORDERID UNION ALL SELECT SUM(ORDERITEMS.qty*INVENTORY.PRICE) / COUNT(DISTINCT ORDERITEMS.ORDERID) AS 'OrderItems_Average' AS 'OrderItems_Average' FROM ORDERITEMS LEFT OUTER JOIN INVENTORY ON ORDERITEMS.PARTID = INVENTORY.PARTID RIGHT OUTER JOIN ORDERS ON ORDERITEMS.ORDERID = ORDERS.ORDERID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)