Who are the advisors for students that live in a city with city code "BAL"?
select advisor from student where city_code = "BAL"