Based on the Tables Below,which of the Following SQL Commands

question 1

Multiple Choice

Based on the tables below,which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo,CustName,RepName? GENERAL SALES DATABASE:
SALESREP
$$\begin{array} { | l | l | l | } \hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Tones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Johnson } & 11 / 23 / 1998 \\\hline\end{array}$$
CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { CustNo } & \text { CustName } & \text { Balance } & \text { SalesRepNo } \\\hline 9870 & \text { Winston } & 500 & 345 \\\hline 8590 & \text { Gonzales } & 350 & 434 \\\hline 7840 & \text { Harris } & 800 & 654 \\\hline 4870 & \text { Miles } & 100 & 345 \\\hline\end{array}$$

• A) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER;
• B) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER
• WHERE CustNo=*;
• C) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER
• WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
• D) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName
• FROM SALESREP, CUSTOMER
• WHERE CustNo=*;
• E) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName
• FROM SALESREP, CUSTOMER
• WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;

---

Definitions:

Credit Balance

The amount of money a business owes to its creditors, represented as a liability on the balance sheet.

Gain on Sale of Land

The financial profit earned from selling land for more than its purchase cost.

Interest Revenue

Income earned from lending money or through investments that pay interest, contributing to a company's overall revenue.

Rent Expense

An expense incurred for using a property or location for business purposes.