CREATE TABLE table_name_27 (player VARCHAR2, years_at_club VARCHAR2, goals VARCHAR2, debut_year VARCHAR2, games VARCHAR2)

Which player debuted before 1943, played for the club in 1942, played less than 12 games, and scored less than 11 goals?
SELECT player FROM table_name_27 WHERE debut_year < 1943 AND games < 12 AND goals < 11 AND years_at_club = "1942"
SELECT "player" FROM "table_name_27" WHERE "1942" = "years_at_club" AND "debut_year" < 1943 AND "games" < 12 AND "goals" < 11