Nina Is Writing a MySQL Query to List the Descriptions

question 7

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

---

Definitions:

Exceptional Boards

Governing bodies of organizations that are highly effective in providing strategic direction, oversight, and support to ensure success and mission fulfillment.

Core Values

Fundamental beliefs or principles that are central to an organization's identity and guide its decisions, actions, and culture.

BoardSource

An organization that specializes in providing support, resources, and training for nonprofit board officers and directors.

Finance Committee

A subgroup within an organization, typically composed of members of its governing body, responsible for overseeing financial policies, strategies, and health.