Python Programming
Friday, November 27, 2015
SQL -- Aggregate Functions (AVG)
Select the average price of all of the items ordered that were purchased in the month of Dec.
SELECT AVG(price)
FROM items_ordered
WHERE order_date LIKE '%Dec%';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment