Alex is a knight, Cody is a knave, and Brook is a spy.

Brook is not the knight, since if he is, then Alex would also be the knight. Cody is not the knight, since his statement would then be a lie. Therefore Alex is the knight, Cody is the knave, and Brook is the spy.