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

question 14

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:

Underpriced

A term describing an asset or security that is sold in the market for less than its intrinsic or true value.

Risk Premium

The extra return expected by an investor for holding a risky asset over a risk-free asset.

Expected Rate

An anticipated return or interest rate forecasted for an investment over a specific period.

Capital Asset Pricing Model

A model that describes the relationship between systematic risk and expected return for assets, particularly stocks, suggesting that the expected return on an investment is related to its risk level.