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:

Trauma Response Team

A group of professionals trained to provide psychological and emotional support immediately after a traumatic event, aiming to minimize the impact of the trauma.

Large-Scale Medical Emergencies

Significant health crises affecting a large population or geographic area, requiring extensive medical intervention and resources.

Suspended

Temporarily halted or postponed, often referring to processes, activities, privileges, or operations until certain conditions are met or resolved.

Computer Technology Industry

A sector focused on the development, manufacturing, and sales of computer hardware, software, and services.