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;

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;

Quizplus · Accepted Answer

Option A selects all the columns from both tables without joining on a common key, which may result in duplicate and irrelevant data.

Option B includes the DISTINCT keyword to filter out duplicates, but it still doesn't specify the join condition between the tables.

Option C joins the tables on the SalesRepNo column but still selects all columns instead of just the desired ones.

Option D is the correct answer as it joins the tables on SalesRepNo and selects only the RepName and CustName columns while filtering for balances greater than 400.

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