Which of the Following Queries Will Output the Table Contents

Multiple Choice

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

A) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';
B) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1];
C) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1) ;
D) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1};