These two expressions are equivalent:
p.age BETWEEN 15 AND 19 p.age >= 15 AND p.age <= 19
The following two expressions are also equivalent:
p.age NOT BETWEEN 15 AND 19 p.age < 15 OR p.age > 19
If an arithmetic expression has a NULL value, then the value of the BETWEEN expression is unknown.