Nina is writing a MySQL query to list the descriptions of items in the CUPCAKES table, which are identified by PROD_ID values. The ORDER_LINE table includes product and quantity information from bakery orders, which are identified by ORDER_NUM values. What can she add to the following query to limit the list to descriptions of cupcakes purchased through order 342? SELECT DESCRIPTION FROM CUPCAKES WHERE
A) PROD_ID IN(ORDER_LINE WHERE(ORDER_NUM = '342'));
B) EXISTS (PROD_ID WHERE (ORDER_LINE.ORDER_NUM = '342'));
C) PROD_ID IN(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342'));
D) PROD_ID EXISTS(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342'));

Question

Quizplus · Accepted Answer

C) is correct because it uses a subquery to select PROD_ID values from the ORDER_LINE table where the ORDER_NUM is '342', and then uses these values to filter the DESCRIPTIONS from the CUPCAKES table where the PROD_ID matches those selected by the subquery.

Nina Is Writing a MySQL Query to List the Descriptions