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 { Jones } & 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; 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;