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:

Fair Value

The price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants.

Going Concern

The assumption that a company will continue in operation for the foreseeable future.

Qualitative Characteristics

Attributes that enhance the usability of financial information, including relevance and faithful representation.