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

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