Assume you have a table: Faculty(SSN (text), Name (text), Rank (text), Salary (real), Phone (text), Specialty (text)) Last month, professor "Jim Carey" from the Sociology specialty was fired and you was asked to remove him from the Faculty table. Is the following SQL going to produce the desired result? DELETE FROM faculty WHERE LOWER(naMe) LIKE '%carey%'; Please explain.