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;

Question

​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;

Quizplus · Accepted Answer

Option A is incorrect because the SUBSTR function has been used incorrectly. The second parameter of the SUBSTR() function specifies the starting position, so it should at least start from the 324th position to retrieve the zip codes starting from position 323.

Option B is incorrect because the WHERE condition is trying to match the entire value of the shipzip column to 323, which is incorrect because the shipzip column contains the full zip code.

Option C is incorrect because the SUBSTR() function has been used incorrectly. To retrieve the first 3 digits of the zip code, we should use SUBSTR(shipzip,1,3) instead of  SUBSTR(shipzip,1,323).

Option D is correct because the WHERE condition uses the SUBSTR() function correctly, and it fetches all the orders with zip codes that start from the first three digits of 323.

​Contents of ORDERS Table

Contents of ORDERS Table