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;

Question

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;

Quizplus · Accepted Answer

This command combines the SALESREP and CUSTOMER tables using a join on the SalesRepNo column, then filters the results to only include rows where the Balance column is greater than 400. Finally, it selects only the RepName and CustName columns to be returned in the result set. This is the most specific and efficient way to get the desired output.

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