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

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;