The inverted conditions result in the SQL you expect,
returning characters whose hit points are less than 100 or who are dead.