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