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:

Mexican Immigrants

Individuals from Mexico who move to another country, especially the United States, in search of better opportunities, often facing challenges including discrimination and acculturation.

Edna Bonacich

An American sociologist known for her work on ethnic and labor relations, especially concerning the economic dynamics of immigration and the exploitation within capitalist societies.

Racial Privileges

Advantages and entitlements granted to individuals based on their race, often at the expense of minority or marginalized groups, contributing to systemic inequality.

Immigrants

People who come to live permanently in a foreign country.