CREATE TABLE table_name_88 (party VARCHAR, name VARCHAR, first_elected VARCHAR, position VARCHAR)

Name the party with first elected more than 1999 and position of supervisor for john foust
SELECT party FROM table_name_88 WHERE first_elected > 1999 AND position = "supervisor" AND name = "john foust"
SELECT "party" FROM "table_name_88" WHERE "first_elected" > 1999 AND "john foust" = "name" AND "position" = "supervisor"