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:

Federalism

A political system that combines a general government (the federal or national government) with regional governments (states or provinces) in a single political system.

Shared Powers

Constitutional powers that are shared by both the state and federal government, allowing for a balance between centralized and local authority.

Federal Judges

Judges appointed by the president and confirmed by the Senate to serve in the federal court system, including the Supreme Court, Courts of Appeals, and District Courts.

Popular Pressure

Influence exerted by public opinion on elected officials or decision-makers to take a specific action or adopt certain policies.