Add a statement to your SQL query that calculates the average total and stores it in a new column as average_total.
NOTE: The three dots (…) indicate where to add the statement.
SELECT
billing_city,
billing_country,
...
FROM
invoice
WHERE
billing_city = "Vancouver"
Correct
You add the statement AVG(total) AS average_total to calculate the average total and store it in a new column as average_total. The complete query is SELECT billing_city, billing_country, AVG(total) AS average_total FROM invoice WHERE billing_city = "Vancouver". The AVG function is an aggregate function that returns the average value of a group of values. The AS command gives a temporary name to the new column.
The average total for Vancouver is 5.51.
