Based on the Code Above,list the Number and Name of All

question 67

Multiple Choice

Based on the code above,list the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file,or both.​

• 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:

Collective Bargaining Agreement

A written contract between an employer and a union representing the employees, detailing the terms of employment, wages, and workplace conditions.

Distributive Bargaining

A negotiation strategy focusing on dividing a fixed amount of resources, often leading to a win-lose scenario.

Labor Management Relationship

The dynamic interaction between labor forces, represented by unions or employees, and management teams within organizations, focusing on negotiation, conflict resolution, and cooperation.

Ideas

Mental representations or concepts that occur in the mind, serving as the building blocks for knowledge, creativity, and problem-solving.