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

question 76

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;

---

Definitions:

Applied Problems

Practical issues or problems that require solutions, often addressed through the application of scientific knowledge and techniques.

Mental Disorders

Health conditions involving changes in emotion, thinking, or behavior (or a combination of these), associated with distress and/or impaired functioning.

Findings

The results or outcomes of a study or research.

Nature

The natural occurrences and features of the earth, encompassing plants, animals, the terrain, and other earth-generated elements, distinct from things made by humans.