If then statement, invalid identifier

Hi all, I'm working with a database of baseball players.  I need to match the contracts in my fantasy baseball league with the season projections I want for each player.  The season projections datab...