Can someone help me to fix the error on this mysql. Thanks!

SELECT student.stuId, student.fname, student.lname, student.major, student.minor, student.credits, IIf(credits>=91,'Senior',IIf(credits>=61,'Junior',IIf(credits>=31,'sophomore',IIf(credits>=0,'freshman')))) AS 'status' WHERE (((student.major)='CSCI')) OR (((student.minor)='CSCI')) FROM student;