The usual logical operators are available:
SQL uses a three-valued logic system with true, false, and
null, which represents “unknown”. Observe the following truth tables:
OR are commutative, that is, you can switch the left and right operand without affecting the result. But see Section 4.2.14 for more information about the order of evaluation of subexpressions.