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

Option A would return all columns from both tables, which is not specified in the requirement. 
Option B uses the DISTINCT keyword unnecessarily and omits the join condition.
Option C returns all columns, which is not specified in the requirement.
Option D is correct because it selects only the required columns and includes the join condition and filter condition necessary to satisfy the requirement. 
Option E uses the GROUP BY clause unnecessarily and doesn't include the join condition.

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