List the advisor IDs for students with eighth year of program and position status in faculty of those professors.
advisor IDs refers to p_id_dummy and person.p_id where professor = 1; eighth year of program refers to yearsInprogram = 'Year_8'; position status in faculty of those professors refers to hasPosition
SELECT T1.p_id_dummy, T2.hasPosition FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram = 'Year_8'
database name:db_id computer_student
course table course Cols: course id dtype integer, course level dtype text, 
person table person Cols: person ID dtype integer, professor dtype integer, student dtype integer, has position dtype text, in phase dtype text, years in program dtype text, 
advisedBy table advisedBy Cols: person id dtype integer, person id dummy dtype integer, 
taughtBy table taughtBy Cols: course ID dtype integer, person ID dtype integer, 
