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 andyou was asked to remove him from the Faculty table. Is thefollowing SQL going to produce the desired result? DELETE FROMfaculty WHERE LOWER(naMe) LIKE ‘%carey%’; Please explain.
Expert Answer
An answer will be send to you shortly. . . . .