CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE voting_record (stuid NUMBER, registration_date CLOB, election_cycle CLOB, president_vote NUMBER, vice_president_vote NUMBER, secretary_vote NUMBER, treasurer_vote NUMBER, class_president_vote NUMBER, class_senator_vote NUMBER)

Show the advisors of the students whose city of residence has city code 'BAL'.
SELECT advisor FROM student WHERE city_code = "BAL"
SELECT "advisor" FROM "student" WHERE "BAL" = "city_code"