Which WHERE clause could be used in the SELECT statement to get the required output?

You need to extract details of those products in the SALES table where the PROD_ID
column contains the string ‘_D123’. Which WHERE clause could be used in the SELECT

statement to get the required output?

A.
WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\’

B.
WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘%_’

C.
WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘_’

D.
WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\_’