Is it an order of operations thing where it's parsing it as... NEW.theorie AND (NOT (...)) >= 180 ...? Try making it < 180, or adding some parenthesis. The unary prefix operators are on their own line in [Operators](https://www.sqlite.org/lang_expr.html#operators), so I'm not really sure where they stand in the list.