Based on the Tables Below,which of the Following Commands in ANSI

question 15

Multiple Choice

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

• A)SELECT * FROM SALESREP,CUSTOMER WHERE Balance > 400;
• B)SELECT DISTINCT RepName,CustName FROM SALESREP,CUSTOMER WHERE Balance > 400;
• C)SELECT * FROM SALESREP,CUSTOMER WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo AND Balance > 400;
• D)SELECT RepName,CustName FROM SALESREP,CUSTOMER WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo AND Balance > 400;
• E)SELECT RepName,CustName FROM SALESREP,CUSTOMER WHERE Balance > 400 GROUP BY SalesRepNo;

---

Definitions:

Analytic Intelligence

A facet of intelligence involved in the ability to analyze, evaluate, judge, compare, and contrast information.

Creative Intelligence

The ability to produce new ideas, solutions, and ways to approach problems that are unique and effective.

Applied Intelligence

The use of cognitive skills and knowledge in practical situations to solve problems effectively.

Cultures

The shared beliefs, practices, norms, and values of a group of people, which influence their behavior and perspectives.