Which of the Following SQL Statements Is a Correctly Stated

question 5

Multiple Choice

Which of the following SQL statements is a correctly stated correlated subquery?

• A)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT S1.SalesRepNo
• FROM SALESREP S1
• WHERE S1.RepName = 'Smith');
• B)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT S1.SaleRepNo
• FROM SALESREP S1
• WHERE S1.RepName = 'Smith')
• AND C1.SalesRepNo=S1.SalesRepNo);
• C)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT S1.SaleRepNo
• FROM SALESREP S1
• WHERE S1.RepName = 'Smith')
• AND C1.SalesRepNo<>S1.SalesRepNo);
• D)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT C2.SaleRepNo
• FROM CUSTOMER C2
• WHERE C1.SalesRepNo=C2.SalesRepNo);
• AND C1.OrderNo<>C2.OrderNo);

---

Definitions:

Flexible Benefits Plans

Employee benefit plans that allow workers to choose from a range of benefit options tailored to their individual needs.

Economies of Scale

Cost advantages that businesses obtain due to their scale of operation, with cost per unit of output generally decreasing with increasing scale.

Benefits Package

A collection of non-wage compensations provided to employees in addition to their salaries or wages. These can include health insurance, pension plans, and vacation time.

Mandatory Benefits

Compulsory employment advantages prescribed by law that an employer must provide to employees, such as social security, workers' compensation, and leave entitlements.