Logical Operators

• AND, TRUE if both expressions are TRUE
• OR, TRUE if either expression is TRUE
• IN, TRUE if the operand is equal to one of a list of expression, the same result with single IN condition, instead of the multiple OR conditions
• NOT IN, allows you to exclude a list of specific values form the result set
• NOT, Returns TRUE if expression is not TRUE

Arithmetic Operators

• '+', addition
• '-', subtraction
• '*', multiplication
• '/', division