SELECT (COUNT(Orders.orderid) / SUM(Inventory.price)) AS Orders_Average FROM ORDERITEMS LEFT OUTER JOIN Inventory ON OrderItems.partid = Inventory.partid RIGHT OUTER JOIN Orders ON OrderItems.orderid = Orders.orderid WHERE NOT EXISTS (SELECT * FROM ORDERITEMS WHERE OrderItems.orderid <> Orders.orderid GROUP BY ORDERITEMS.orderid)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)