Skip to content

Instantly share code, notes, and snippets.

@aj-justo

aj-justo/ZenCart_SQL_Get_Orders_Total_Average

Created May 27, 2011 10:31
Show Gist options
  • Save aj-justo/995010 to your computer and use it in GitHub Desktop.
Save aj-justo/995010 to your computer and use it in GitHub Desktop.
Download ZIP
Zen Cart SQL: Get average order total for given time period
Raw
ZenCart_SQL_Get_Orders_Total_Average
SELECT AVG(o.order_total),COUNT(*)
FROM orders o, `orders_total` ot
WHERE o.orders_id=ot.orders_id AND
o.orders_status=3 AND
o.date_purchased BETWEEN '2010-4-01' AND '2010-4-31'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment