<div>
What is your desired outcome? &nbsp;Your query has no problems if you are wanting just the 2 numbers for total sales amount divided by total number of rows in the orders table and total number of rows in the orderitems table. &nbsp;If you are expecting something else, describe it a little more.
</div>


What is your desired outcome?  Your query has no problems if you are wanting just the 2 numbers for total sales amount divided by total number of rows in the orders table and total number of rows in the orderitems table.  If you are expecting something else, describe it a little more.

<div>
<div class="content wysiwyg-content">
I am gettig the average dollar value of an Order. &nbsp; Just need to double check if this query is missing anything since &nbsp;<br />
<br />
<b>there are a certain number of orders in the ORDERS table, but not all of these orders are in the ORDERITEMS table.</b> &nbsp; <br />
<br />
SELECT &nbsp;SUM(ORDERITEMS.qty*INVENTO<wbr />RY.PRICE) / COUNT(ORDERS.ORDERID) AS <b>'Orders_Average'</b><br />
&nbsp; <br />
&nbsp; , &nbsp;SUM(ORDERITEMS.qty*INVENTO<wbr />RY.PRICE) / COUNT(ORDERITEMS.orderid) &nbsp;AS <b>'OrderItems_Average'</b><br />
&nbsp; <br />
&nbsp;<br />
FROM &nbsp;ORDERITEMS LEFT OUTER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;INVENTORY ON ORDERITEMS.PARTID = INVENTORY.PARTID RIGHT OUTER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ORDERS ON ORDERITEMS.ORDERID = ORDERS.ORDERID
</div>
</div>


I am gettig the average dollar value of an Order.   Just need to double check if this query is missing anything since  

there are a certain number of orders in the ORDERS table, but not all of these orders are in the ORDERITEMS table.   

SELECT  SUM(ORDERITEMS.qty*INVENTORY.PRICE) / COUNT(ORDERS.ORDERID) AS 'Orders_Average'
  
  ,  SUM(ORDERITEMS.qty*INVENTORY.PRICE) / COUNT(ORDERITEMS.orderid)  AS 'OrderItems_Average'
  
 
FROM  ORDERITEMS LEFT OUTER JOIN
               INVENTORY ON ORDERITEMS.PARTID = INVENTORY.PARTID RIGHT OUTER JOIN
               ORDERS ON ORDERITEMS.ORDERID = ORDERS.ORDERID

SQL Query - get average dollar of an order withou using AVG()

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.