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:

Increased Homelessness

A rising phenomenon or trend where more individuals lack stable, permanent, and adequate nighttime residence.

Electroconvulsive Therapy (ECT)

A psychiatric treatment in which seizures are electrically induced in anesthetized patients for therapeutic effect, primarily in severe mood disorders.

Behavioural Treatment

A range of therapeutic interventions and techniques focused on modifying problematic behaviors and developing positive ones.

Group Therapy

A form of psychotherapy involving one or more therapists working with several people at the same time, often used for sharing experiences and learning from others in a supportive environment.