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 sum the sales made to each customer by the following entries:

Which SQL query should you use?

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 sum the sales made to each customer by the following entries:

Which SQL query should you use?

Accepted Answer

A. Option A

Answer

B. Option B

Answer

C. Option C

Answer

D. Option D

Answer

E. Option E

Answer

F. Option F

Answer

G. Option G

Answer

H. Option H

Answer

J. Option J

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 sum the sales made to each…