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

Question

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

Quizplus · Accepted Answer

The correct answer is A because it uses the INITCAP() function to capitalize the first letter of each word in the concatenated string, resulting in the desired format of "City, State Zip".

Contents of the CUSTOMERS Table