I think I got it, if anyone sees a problem with this please let me know, just don't tell my Marketing department

SELECT orders.idOrder, SUM(ProductsOrdered.quantity) as "Total Products"

FROM orders INNER JOIN ProductsOrdered ON orders.idOrder = ProductsOrdered.idOrder

WHERE ((orderStatus > 2 AND orderStatus < 5) OR (orderStatus > 6 AND orderStatus < 9)) AND orderDate >= '01/01/2006' AND orderDate <= '12/31/2006'

GROUP BY orders.idOrder

order by orders.idOrder;

I need a little help with some SQL.  We are registering with shop.org and they are asking for some data on our site.  Could someone help me with the query for:

Average Number of Items Per Order for 2006

Thanks in advance for any help.  I've busted out the old college database books and it scares me.