Based on the Tables Below,which of the Following ANSI SQL

question 63

Multiple Choice

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

• A)SELECT AVG (Balance) FROM CUSTOMER WHERE SalesRepNo;
• B)SELECT AVG (Balance) FROM CUSTOMER GROUP BY SalesRepNo;
• C)SELECT AVG (Balance) FROM CUSTOMER,SALESREP WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo;
• D)SELECT AVG (Balance) FROM CUSTOMER ORDER BY SalesRepNo;
• E)SELECT AVG (Balanc
• E) FROM CUSTOMER,SALESREP WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo HAVING SalesRepNo;

---

Definitions:

First Alternative

The initial solution or option considered in decision-making or problem-solving processes.

Consultative Decisions

Decision-making processes where input or feedback is sought from others, especially those who will be affected by the decision, before a final choice is made.

5-Step Process

A structured approach to problem-solving or project management, typically involving stages such as planning, implementation, and evaluation.

Availability Heuristic

A mental shortcut that relies on immediate examples that come to a given person's mind when evaluating a specific topic, concept, method, or decision.