And what is his occupation?
SELECT occupation from player WHERE Player_name LIKE "Jim%"
his occupation refers to the occupation column; Player_name LIKE \"Jim%\" refers to players whose names start with 'Jim';