Order of Precedence

The rules of precedence determine the order in which expressions are evaluated and calculated. You can override the default order by using parenthesis around the expressions that you want to calculate first. This table lists the default Order of Precedence

1. Arithmetic Operators
2. Concatenation Operator
3. Comparison Conditions
4. IS [NOT] NULL, LIKE, [NOT] IN
5. [NOT] BETWEEN
6. Not Equal to
7. NOT logical condition 
8. AND 
9. OR