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:

Ultrasonic Cleaner

A device that uses ultrasonic waves in a liquid to clean small, intricate objects or parts, particularly effective in removing dirt and contaminants.

Sound Waves

Vibrations that travel through the air or another medium, perceptible to the human ear as sound.

Sphygmomanometer

An instrument used to measure blood pressure, typically consisting of an inflatable cuff to restrict blood flow and a manometer to measure the pressure.

Otoscope

A medical instrument used by doctors to examine the ear canal and tympanic membrane.