Use the Database Below to Answer the Following Question CUSTOMER

question 44

Essay

Use the database below to answer the following question.
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}$$
Given that a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name as SalesRepresentativeName has been created for the GENERAL SALES DATABASE,write the SQL code to use the view to display the customer name and associated sales rep name sorted by customer name.

---

Definitions:

Marketing Research

A systematic, objective process of getting information about potential customers to guide marketing decisions.