CREATE TABLE table_name_79 (player VARCHAR2, first_team_appearances VARCHAR2)

Who is the player who has had 7 first team appearances?
SELECT player FROM table_name_79 WHERE first_team_appearances = "7"
SELECT "player" FROM "table_name_79" WHERE "7" = "first_team_appearances"