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