CREATE TABLE table_204_26 (id NUMBER, "name" CLOB, "position" CLOB, "birth date/age at start of campaign" CLOB, "games in campaign" CLOB, "club" CLOB)

who is the only player to play in 5 games , 1 as a sub ?
SELECT "name" FROM table_204_26 WHERE "games in campaign" = 5 AND "games in campaign" = '1 as sub'
SELECT "name" FROM "table_204_26" WHERE "games in campaign" = '1 as sub' AND "games in campaign" = 5