%VO ... 46 4G+ : TIL You have a table Teacher(teacherID,tname,sal ary,address). And table student(studentiD,sname, advisorID). advisorld is the id of teacher who is the academic advisor for student. What is the SQL statement that finds student name and the name of his advisor? Select one: o a. select sname,tname from student,teacher; O b. select sname,tname from student where advisorID=teacher.teacherlD; c. select sname,tname from student,teacher where student.advisorID=teacher.teacherID; d. select sname,tname from student,teacher order by advisorID