Microsoft
70-433 · Question #478
You are a developer for a Microsoft SQL Server 2008 R2 database instance. You create tables named order, customer, and product as follows: You need to write a query to identify all customers who…
The correct answer is E. Option E. See the full explanation below for the reasoning.
Question
You are a developer for a Microsoft SQL Server 2008 R2 database instance. You create tables named order, customer, and product as follows: You need to write a query to identify all customers who have ordered for an average amount of more than 500 or more from September 01, 2011. Which SQL query should you use?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
- FOption F
- GOption G
- HOption H
- JOption J
How the community answered
(44 responses)- A2% (1)
- B2% (1)
- C7% (3)
- E84% (37)
- G5% (2)
Community Discussion
No community discussion yet for this question.