CREATE TABLE table_name_97 (club VARCHAR, player VARCHAR)

What club wast he player hristo stoitchkov from?
SELECT club FROM table_name_97 WHERE player = "hristo stoitchkov"
SELECT "club" FROM "table_name_97" WHERE "hristo stoitchkov" = "player"