What state has Richard Foster as a member?
CREATE TABLE "notes" (
  "member" text,
  "party" text,
  "electorate" text,
  "state" text,
  "first_elected" text
);
SELECT "state" FROM "notes" WHERE "member"='richard foster';