Schema: CREATE TABLE STUDENT (Advisor VARCHAR, city_code VARCHAR)
Question: Who are the advisors for students that live in a city with city code "BAL"?
SQL: SELECT Advisor FROM STUDENT WHERE city_code = "BAL"