Contents of the CUSTOMERS Table

Multiple Choice

Contents of the CUSTOMERS table
​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

A) SELECT customer#,city,SUBSTR(state,'FL','FLORIDA') FROM customers
WHERE state = 'FL';
B) SELECT customer#,city,SUBSTR( 'FL','FLORIDA') FROM customers
WHERE state = 'FL';
C) SELECT customer#,city,REPLACE( 'FL','FLORIDA') FROM customers
WHERE state = 'FL';
D) SELECT customer#,city,REPLACE(state,'FL','FLORIDA') FROM customers
WHERE state = 'FL';