Drag the edges to resize the window.

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.