The unary expression is an expression the prefixed with operators
!
takes truth to falsity and vice versa. It is typically used with boolean
SELECT * FROM branches WHERE !is_remote
SELECT * FROM branches WHERE !is_head
-
negates the value of the operand.
SELECT * FROM branches WHERE commit_count > -1