Database: activity_1
Question: Which students have professors as their advisors? Find their student ids.
SQL:
SELECT T2.StuID FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T1.rank  =  "Professor"