​Contents of ORDERS Table

Multiple Choice

​Contents of ORDERS table
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-​Based upon the contents of the ORDERS table,which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

A) SELECT order#,SUBSTR(shipzip,1,323)
FROM orders;
B) SELECT order#,SUBSTR(shipzip,1,323)
FROM orders
WHERE shipzip = 323;
C) SELECT order#
FROM orders
WHERE shipzip = SUBSTR(shipzip,1,323) ;
D) SELECT order#
FROM orders
WHERE SUBSTR(shipzip,1,3) = 323;