Solved

What Would the Following View Contain for Values

Question 62

Multiple Choice

What would the following view contain for values?
Create view CustomerOrders as
Select CustID, Count(*) as TotOrders, Sum(ordertotal) as Value
From customer inner join sale on customer.customer_id = sale.customer_id;


A) A listing of all customers in the customer table
B) A listing of the customer ID as well as the total number of orders and the total amount spent by the customer
C) A listing of the customer ID as well as the total orders
D) An error message

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions