PrepAway - Latest Free Exam Questions & Answers

which clause should you insert this expression?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
ON

B.
WHERE

C.
HAVING

D.
GROUP BY


Leave a Reply