We have to pass the column name as a parameter. The avg() function has the following syntax: SELECT AVG( column_name ) FROM table_name; The avg() function can be used with the SELECT query for retrieving data from a table

The column name must be given as a parameter. The syntax for the average() function is as follows: SUM(column_name) FROM table_name; To retrieve data from a table, use the average() method in conjunction with the SELECT query.