Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Learn

Congratulations! You just learned how to use aggregate functions to perform calculations on your data. What can we generalize so far?

  • Aggregate functions combine multiple rows together to form a single value of more meaningful information.
  • COUNT takes the name of a column(s) as an argument and counts the number of rows where the value(s) is not NULL.
  • GROUP BY is a clause used with aggregate functions to combine data from one or more columns.
  • SUM() takes the column name as an argument and returns the sum of all the values in that column.
  • MAX() takes the column name as an argument and returns the largest value in that column.
  • MIN() takes the column name as an argument and returns the smallest value in that column.
  • AVG() takes a column name as an argument and returns the average value for that column.
  • ROUND() takes two arguments, a column name and the number of decimal places to round the values in that column.
Report a Bug
If you see a bug or any other issue with this page, please report it here.