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

question 15

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:

Inflation

The pace at which the full spectrum of goods and services' pricing ascends, weakening the power of acquisition.

Value Of Money

The purchasing power of money, or the amount of goods and services that one unit of money can buy, often influenced by inflation.

Market Outcomes

The results of economic transactions and interactions in a market, including prices and quantities of goods and services traded.

Scarce Resources

Resources that are limited in availability and can run out if not used efficiently, leading to the necessity of making choices on how to allocate them.