​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 will display the shipping location as:
Shipcity,Shipstate Shipzip​

A) SELECT INITIALCAP(CONCAT(shipcity,shipstate,shipzip) )
FROM orders;
B) SELECT INITCAP(CONCAT(shipcity,CONCAT(',',CONCAT(shipstate,
CONCAT(' ',shipzip) ) ) ) )
FROM orders;
C) SELECT INITCAP((CONCAT(shipcity,shipstate,shipzip) )
FROM orders;
D) SELECT INITCAP(CONCAT(shipcity,CONCAT(',',CONCAT(shipstate,
CONCAT(' ',CONCAT(shipzip) ) ) ) ) )
FROM orders;