Question

column called average total. add a statement to your sql query that calculates the average total and stores it in a new column as average total.

Answer 1

SELECT AVG( average_total ) as 'average total' FROM some_table;

Step-by-step explanation:

For this, we need to use avg() function. We have to pass the column name as a parameter. The avg() function has the following syntax:

SELECT AVG( column_name ) FROM table_name;