<div>
By &quot;items&quot; are you referring to the quantity? As in quantity of items?
</div>


<div>
here's a start
<pre><code id="code-20-39335291-1">select
          num_of_orders
        , num_of_products
        , tot_rows / num_of_orders as avg_items_per_order
from (
        select
                  count(*) as tot_rows
                , count(distinct [Order number]) as num_of_orders
                , count(distinct [product code]) as num_of_products
        from sometable
     ) as derived</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I have a table that contains the the following fields:<br />
Order number , product code and quantity. Most of the orders have multiple lines.<br />
What would be the best way to determine the following:<br />
Total number of orders<br />
Number of orders that have<br />
1-5 items<br />
5-20 items<br />
20-50 items<br />
50 plus items<br />
<br />
Also average number of products per order,<br />
Average number of items per order<br />
Any help would be appreciated<br />
Thanks
</div>
</div>


I have a table that contains the the following fields:
Order number , product code and quantity. Most of the orders have multiple lines.
What would be the best way to determine the following:
Total number of orders
Number of orders that have
1-5 items
5-20 items
20-50 items
50 plus items

Also average number of products per order,
Average number of items per order
Any help would be appreciated
Thanks

By &quot;items&quot; are you referring to the quantity? As in quantity of items?

Calculations

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.