CREATE TABLE table_name_42 (player VARCHAR2, position VARCHAR2, pick__number VARCHAR2)

Which player has a Position of defence, and a Pick # of 6?
SELECT player FROM table_name_42 WHERE position = "defence" AND pick__number = "6"
SELECT "player" FROM "table_name_42" WHERE "6" = "pick__number" AND "defence" = "position"