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';

Go Back to previous Aggregate Functions page

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved