Database: activity_1
Question: Show the ids of students whose advisors are professors.
SQL:
SELECT T2.StuID FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T1.rank  =  "Professor"