CREATE TABLE table_name_90 (occupation VARCHAR2, residence VARCHAR2)

What job is at red bank?
SELECT occupation FROM table_name_90 WHERE residence = "red bank"
SELECT "occupation" FROM "table_name_90" WHERE "red bank" = "residence"