Based on the Code Shown, Which Query Lists the Number

question 23

Multiple Choice

Based on the code shown, which query lists the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ;
• B) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ;
• C) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ;
• D) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ;

---

Definitions:

Incremental Sales

Additional sales generated by a new promotional strategy or marketing campaign, beyond the expected or normal sales volume.

Operating Expenses

Costs that a business incurs through its normal business operations, excluding the cost of goods sold.

Renovation Cost

Expenses incurred in updating or improving a fixed asset, such as buildings or equipment, to increase its value or extend its useful life.

Working Capital

The contrast between a firm's current holdings and its due obligations, highlighting the accessible funds for running its business activities.