How to explain this logic and ways to avoid?

Question

Hi Team

 

I have this query, how do you explain this result and ways to avoid that it does not happen in sql server.?

SELECT * FROM runners WHERE id NOT IN (SELECT winner_id FROM races)

// output

Id column empty
name column empty