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

Question

Quizplus · Accepted Answer

The query selects invoice numbers from the INVOICE_LINE table where the product code matches those found in the PRODUCTS table with a product type of 'Cupcake'. This means it lists the invoice numbers for invoices that include line items with a "Cupcake" product type.

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