OK. Which instructor ids appear more than once in the advisor table
SELECT T1.id FROM instructor AS T1 JOIN advisor AS T2 ON T1.id   =   T2.i_id GROUP BY T2.i_id HAVING count ( * )   >  1
instructor ids appear more than once refers to COUNT(*) > 1;