Schema: CREATE TABLE table_name_90 (occupation VARCHAR, residence VARCHAR)
Question: What job is at red bank?
SQL: SELECT occupation FROM table_name_90 WHERE residence = "red bank"