The Student table has the following columns:FirstName $-$ VARCHAR$(20)$

LastName $-$ VARCHAR$(20)$

Major $-$ CHAR$(4)$Complete the SELECT statement to return a string containing the student's major, with all occurrences of 'BIO' replaced with 'CHEM'. SELECT

FROM Student;