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:

Advanced Counseling

A level of counseling practice that incorporates deeper therapeutic techniques and approaches, often implying a higher level of expertise and training in the field.

Relapse Prevention

A strategy in addiction treatment and mental health for reducing the likelihood of returning to unhealthy behaviors after making progress towards recovery.

Physical Activity

Any bodily movement produced by skeletal muscles that requires energy expenditure, such as exercise or sports.

Motivational Counseling

An approach that centers on the client and boosts the desire to change from within through the examination and resolution of uncertainties.