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

Question

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

Quizplus · Accepted Answer

The view aggregates data from the customer and sale tables, showing each customer's ID, total number of orders, and total amount spent.

What Would the Following View Contain for Values