The SELECT statement that queries the invoice table to find the total cost for all orders placed between 2009-01-01 and 2010-01-01 is:
SELECT AVG(total)
FROM invoice
WHERE invoice_date BETWEEN '2010-01-01' AND '2011-01-01';
What is a SELECT statement?
This refers to the command that is used in SQL to retrieve zero or more rows from different database tables or database views
Hence, we can see that the SELECT statement is given above as it queries the invoice table to find the total cost for all orders placed between 2009-01-01 and 2010-01-01.
Read more about SELECT statements here:
https://brainly.com/question/19338967
#SPJ1
