Use the Database Below to Answer the Following Question CUSTOMER


Write the SQL Statement to Create a SALES

question 61

Essay

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP
$\begin{array} { | l | l | l | } \hline \text { SalesRepNe } & \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


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:

Lower Level

A term referring to items, operations, or components that are considered to be at a more basic or foundational tier within a hierarchy.

Calculation

The process of determining a result through mathematical or logical operations, often automated in software applications.

Table Cell

The intersection point of a row and column in a table, which can contain data, text, or graphical elements within a structured format.

Symbol

A symbol is a visual object or mark that represents an idea, object, or relationship, used in various contexts from mathematics to literature.