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

Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.