Contents of the CUSTOMERS Table

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

A) ​SELECT LOWER(name) FROM customers;
B) ​SELECT LOWER(firstname) || ' ' || LOWER(lastname) FROM customers;
C) ​SELECT CONCAT(LOWER(firstname) ,' ',LOWER(lastname) ) FROM customers;
D) ​none of the above