Which of the Following SQL Statements Is a Correctly Stated

question 92

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.SaleRepNo
• 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);
• E)None of the above is a correctly stated correlated subquery.

---

Definitions:

Generation Y

Also known as Millennials, the demographic cohort following Generation X, typically defined as those born from the early 1980s to the mid-1990s to early 2000s.

Middle-Aged Adults

Individuals typically in the age range of 45 to 65 years old, who are often experiencing transitional life events.

Human Relations

refers to the interactions and relationships between individuals in a personal or professional setting.

Internal Customers

Employees or departments within an organization that depend on the support of one another to complete their tasks.