In plain words
Count a win as plus one, a loss as minus one, and a tie as zero each. In a zero-sum game the players’ results always add up to zero. Nobody can come out ahead unless somebody else comes out behind. A non-zero-sum game is any game where that is not true, so that everyone can win or everyone can lose.
See it
Tennis is zero-sum: one winner, one loser. Two people building a sandcastle is non-zero-sum: both can go home happy, or the tide can beat them both.
Why designers care
Zero-sum is a decision, though it’s easy to mistake for the default because most sports work that way. Cooperative board games, building toys, and plenty of party games are non-zero-sum. Ask early whether anyone needs to lose for your game to be fun.
Common mix-up
Zero-sum does not mean “competitive.” Players can compete fiercely in a game where both still end up better off.
Origin Game theory, John von Neumann and Oskar Morgenstern (1944).