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:

Equity Method

An accounting technique used to record investments in which the investor has significant influence over the investee but does not have full control.

Carrying Value

The book value of an asset or liability on a company's balance sheet, calculated as the asset's original cost minus accumulated depreciation, amortization, or impairment charges.

Investment Income

Income earned from investments such as dividends on stocks, interest on bonds, or rental income from property.

Equity Method

The equity method is an accounting technique used for recording investments in other companies, where the investment is initially recorded at cost and adjusted thereafter for the investing company’s share of the investee’s profits or losses.