Average Items Per Order

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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.

Edited by MOlson - 14-February-2007 at 6:14pm

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
MOlson Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 16-November-2005 Status: Offline Points: 0	Post Options Post Reply Quote MOlson Report Post Thanks(0) Quote Reply Topic: Average Items Per Order Posted: 14-February-2007 at 6:14pm
	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. Edited by MOlson - 14-February-2007 at 6:14pm

MOlson Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 16-November-2005 Status: Offline Points: 0	Post Options Post Reply Quote MOlson Report Post Thanks(0) Quote Reply Posted: 16-February-2007 at 1:07pm
	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;