and use the as command to store the result in a new 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.