What Does the Following SQL Query Do? SELECT INVOICE_NUM FROM INVOICE_LINE

question 29

Multiple Choice

What does the following SQL query do? SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake') ) ;

• A) cause an error because it includes more than one SELECT command
• B) lists all rows from the invoice line table that contain a "Cupcake" type product
• C) lists the invoice numbers for invoices containing line items with a "Cupcake" product type
• D) lists the product codes for all "Cupcake" type products that appear on invoices

---

Definitions:

Federal Law

Law that is made by the federal government and applies across all states in the United States.

Tort Law

A legal domain that addresses wrongs or harms caused by one party to another, resulting in legal liability.

Consent

Agreement or permission given by a person with full understanding of the facts and implications of an action or decision.

Battery

A criminal offense involving the unlawful physical acting upon a threat, distinct from assault which is the act of creating apprehension of such contact.