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:

Bacon Cheeseburgers

A hamburger topped with bacon and cheese, serving as a popular American fast food dish.

Price Decreases

Reductions in the cost of goods or services, often leading to increased demand.

Normal Goods

Goods for which demand increases as the income of individuals increases, indicating a positive relationship between income and demand.

Equilibrium Price

This is the price at which the quantity of goods supplied matches the quantity of goods demanded, resulting in market equilibrium.