SQL QUERY在不使用AVG（）的情况下获得平均值的问题 [英] SQL QUERY Question to get Average without using AVG()

问题描述

如何修改下面的查询以显示订单的平均美元价值和 OrderItems <的平均美元价值 / u> 在列中并排。下面的查询将它们组合在一起。谢谢。

How can I modify the query below to show "average dollar value for Orders" and "average dollar value for OrderItems" side by side in columns. The query below would combine them. Thank you.

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)

推荐答案

嗨


平均而言，你需要做总数而不是计数/总和。

Hi
For average you need to do Sum over count and not count/sum.

这篇关于SQL QUERY在不使用AVG（）的情况下获得平均值的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！