Nina Is Writing a MySQL Query to List the Descriptions

Multiple Choice

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') ) ;