SQLCourse
Interactive Online SQL Training
HOME News MS SQL Oracle DB2 Access MySQL PHP SQL Etc Scripts Links Forums DBA Talk
SQL Courses
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Free Newsletters:



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


SQL Course Curriculum
<<previous 1234567891011121314 next>>