CREATE TABLE table_name_65 (player VARCHAR2, position VARCHAR2, round VARCHAR2)

Who has a round less than 9 and a position of G?
SELECT player FROM table_name_65 WHERE position = "g" AND round < 9
SELECT "player" FROM "table_name_65" WHERE "g" = "position" AND "round" < 9