You are writing a query that returns a list of products that have grossed more than $10,000.00 during the year 2007. You need to insert the following filter expression into the query. SUM([Order Details].UnitPrice * [Order Details].Quantity) 10000 Into which clause should you insert this expression?

Question

You are writing a query that returns a list of products that have grossed more than $10,000.00 during the year 2007. You need to insert the following filter expression into the query. SUM([Order Details].UnitPrice * [Order Details].Quantity) > 10000 Into which clause should you insert this expression?

Accepted Answer

C. HAVING

Answer

A. ON

Answer

B. WHERE

Answer

D. GROUP BY

You are writing a query that returns a list of products that have grossed more than $10,000.00 during the year 2007. You need to insert the following filter expression into the query. SUM([Order…

Question

Options

How the community answered

Community Discussion