Contents of the CUSTOMERS Table​

question 39

Multiple Choice

Contents of the CUSTOMERS table​

-​Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

• A) ​SELECT customer# FROM customers WHERE customer# = (SELECT state FROM customers WHERE state = 'NJ');
• B) ​SELECT customer# FROM customers WHERE state = (SELECT state FROM customers WHERE customer#=1013);
• C) ​SELECT customer# FROM customers WHERE customer# IN (SELECT state FROM customers WHERE state = 'NJ');
• D) ​SELECT customer# FROM customers WHERE state EXISTS (SELECT state FROM customers WHERE customer#=1013);

---

Definitions:

Spina Bifida

A congenital anomaly characterized by the incomplete closure of the spine and the surrounding membranes of the spinal cord.

Digestive System

The system of organs responsible for processing food, absorbing nutrients, and eliminating waste products from the body.

Cerebral Palsy

A neurological disorder caused by a non-progressive brain injury or malformation that occurs while the child's brain is under development, affecting motor skills and muscle coordination.

Spina Bifida

A developmental anomaly involving the spine and membranes around the spinal cord not fully enclosing.