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

---

Definitions:

Prediction Interval

A range of values that is likely to contain the value of an unknown parameter for a future observation, with a specified level of confidence.

Expected Value

In probability and statistics, it is the average value obtained from numerous trials of an experiment over an extended period.

Confidence Interval

A compilation of values, resulting from the statistical study of samples, aimed to likely capture the value of an unknown population parameter.

Long-Run Average

Refers to the average of a set of values or outcomes over a long period of time, often used in economics to predict long-term equilibrium or trends.