Which aggregate function calculates the arithmetic mean of a column?

SQL Fundamentals Easy

SQL Fundamentals — Easy

Which aggregate function calculates the arithmetic mean of a column?

Key points

  • AVG() calculates the average value
  • MEAN() and AVERAGE() are not valid SQL functions for calculating the mean
  • MID() is used for extracting a substring from a string

Ready to go further?

Start full exam Practice more questions

Related questions