Use the Database Below to Answer the Following Question CUSTOMER

question 65

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 { Tones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Tohnson } & 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}$$
Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.

---

Definitions:

Manage Emotion

The process of recognizing, understanding, and effectively controlling one's own emotions and those of others, to facilitate positive interactions and achieve goals.

Recognize Emotion

The ability to identify and understand the emotions of oneself and others.

Emotional Contagion

The phenomenon where emotions are transferred from one person to another, either consciously or unconsciously, often influenced by nonverbal cues.

Nonverbal Channels

Methods of communication that do not involve words, such as body language, facial expressions, and gestures.