Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME - ------------------- Renske Ladwig - Jason Mallin - Samuel McCain - Allan MCEwen - Irene Mikkilineni - Julia Nayer - You need to display customers` second names where the second name starts with "Mc" or "MC". Which query gives the required output? 

Answer options:

A. SELECT SUBSTR(cust_name, INSTR (cust_name, ` `)+1) FROM customers WHERE SUBSTR(cust_name, INSTR (cust_name, ` `)+1) LIKE INITCAP (`MC%`);
B. SELECT SUBSTR(cust_name, INSTR (cust_name, ` `)+1) FROM customers WHERE INITCAP(SUBSTR(cust_name, INSTR (cust_name, ` `)+1)) = `Mc`;
C. SELECT SUBSTR(cust_name, INSTR (cust_name, ` `)+1) FROM customers WHERE INITCAP(SUBSTR(cust_name, INSTR (cust_name, ` `)+1)) LIKE `Mc%`;
D. SELECT SUBSTR(cust_name, INSTR (cust_name, ` `)+1) FROM customers WHERE INITCAP(SUBSTR(cust_name, INSTR (cust_name, ` `)+1)) = INITCAP (`MC%`);

C