Aggregate Function Exercise Answers
Exercise #1
SELECT max(price)
FROM items_ordered;
Exercise #2
SELECT avg(price)
FROM items_ordered
WHERE order_date LIKE '%Dec%';
Exercise #3
SELECT count(*)
FROM items_ordered;
Exercise #4
SELECT min(price) FROM items_ordered WHERE item = 'Tent';