Based on the Tables Below, Which Command Creates a New

question 22

Multiple Choice

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum) ?SalesPerson (SalesPersonNum, LastName, FirstName)

• A) PROJECT Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
• B) UNION Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
• C) SELECT Customer SalesPerson JOIN Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales
• D) JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales

---

Definitions:

Industrial Technologies

Advanced systems and equipment used to improve manufacturing processes and productivity in the industrial sector.

Wilson Administration

The presidential term of Woodrow Wilson, the 28th President of the United States, who served from 1913 to 1921, known for leading the U.S. through World War I and advocating for the League of Nations.

Mexican Revolution

A major armed struggle from 1910 to 1920 that transformed Mexican culture and government, marked by the fight against autocracy and inequality.

American Expeditionary Force

The U.S. military forces sent to Europe during World War I under the command of General John J. Pershing.