What will be the output of the following MySQL statement?

SELECT account_id, product_id, cust_id
FROM account
WHERE product_id IN (‘sav’, ‘chd’, ‘mm’);

A. Only those values are selected whose product_id is either 'sav', 'chd', 'mm'

B. Only those values are selected whose product_id is either 'sav''

C. Only those values are selected whose product_id is either 'sav', 'chd'

D. All of the mentioned

Answer: Option A

Solution(By Examveda Team)

The given SQL statement selects rows from the account table where the product_id column matches any of the specified values: 'sav', 'chd', or 'mm'. The IN operator is used to specify a list of values to match against. Therefore, the output of the statement will be:
Only those values are selected whose product_id is either 'sav', 'chd', or 'mm'. So, the correct answer is Option A: Only those values are selected whose product_id is either 'sav', 'chd', 'mm'.