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:

DineEquity

A company known for owning and operating restaurant brands, including Applebee's and IHOP.

Data

Facts and statistics collected together for reference or analysis, used to make decisions or solve problems.

Information

Data that has been processed, organized, or presented in a way that gives it meaning or context.

Media Richness

The capacity of a communication medium to effectively convey complex information in a timely manner.