HI,
Change your code to :
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)
NO need to define the having clause with aliase name.
Thanks