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_country,
...
FROM
invoice
WHERE
billing_country = "India"
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_country, AVG(total) AS average_total FROM invoice WHERE billing_country = "India". 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 India is 5.78.
