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

question 14

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:

Consciousness Raising

The activity of seeking to make people more aware of personal, social, or political issues, often used in the context of social movements and therapy.

Therapist Confrontation

A therapeutic technique where the therapist challenges the client's beliefs or behaviors to facilitate insight and change.

Client Value Judgments

The personal beliefs and evaluations made by clients about what is important in their lives, which can influence their decisions and behaviors in therapy.

Therapeutic Relationship

The professional bond between a therapist and client, which is crucial for the effectiveness of the therapy.