Contents of the CUSTOMERS Table

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-Based upon the contents of the CUSTOMERS table,which of the following will display the shipping location as:
City,State Zip​

A) SELECT INITCAP(CONCAT(city,CONCAT(',',CONCAT(state,
CONCAT(' ',zip) ) ) ) )
FROM customers;
B) SELECT CONCAT(city,CONCAT(',',CONCAT(state,
CONCAT(' ',CONCAT(zip) ) ) ) )
FROM customers;
C) SELECT INITCAP(CONCAT(city,',',state,' ',zip) )
FROM customers;
D) ​none of the above