CREATE TABLE table_name_92 (player VARCHAR2, position VARCHAR2, club_province VARCHAR2)

Which Player has a Position of number 8, and a Club/province of scarlets?
SELECT player FROM table_name_92 WHERE position = "number 8" AND club_province = "scarlets"
SELECT "player" FROM "table_name_92" WHERE "club_province" = "scarlets" AND "number 8" = "position"