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 is a valid SQL statement based upon the contents of the CUSTOMERS table?

A) ​SELECT INITCAP(firstname,lastname) FROM customers;
B) ​SELECT LENGTH (city,state,zip) FROM customers;
C) ​SELECT customer#,NVL2(referred,'Referred','Not Referred') FROM customers;
D) ​SELECT INITCAP((firstname) , ( lastname) ) FROM customers;