-- Database schema
| course : course_id [ INTEGER ] primary_key , courseLevel [ TEXT ] | person : p_id [ INTEGER ] primary_key , professor [ INTEGER ] , student [ INTEGER ] , hasPosition [ TEXT ] , inPhase [ TEXT ] , yearsInProgram [ TEXT ] | advisedBy : p_id [ INTEGER ] advisedBy.p_id = person.p_id , p_id_dummy [ INTEGER ] advisedBy.p_id_dummy = person.p_id | taughtBy : course_id [ INTEGER ] taughtBy.course_id = course.course_id , p_id [ INTEGER ] taughtBy.p_id = person.p_id |
-- -- Find the ID of advisor of student ID 80 and state the level of courses taught by him/her.

SELECT T1.p_id_dummy, T2.courseLevel FROM advisedBy AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T2.course_id = T3.course_id WHERE T1.p_id = 80;