Who are the advisors for students that live in a city with city code "BAL"?
create table student (advisor varchar, city_code varchar, PRIMARY KEY (advisor))
select advisor from student where city_code = "bal"