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:

Genetic Code

The collection of guidelines that dictate how information stored in genetic material, whether DNA or RNA sequences, is converted into proteins by living organisms.

Universality

The quality of being universal; applicable or relevant to all cases, conditions, or situations.

Fossil

Parts or traces of an ancient organism usually preserved in rock.

Organism

An individual living entity that can react to stimuli, reproduce, grow, and maintain homeostasis.