Table 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"