1. The predicates can be more complicated, and can involve

• Logical connectives and, or and not.
• Arithmetic expressions on constant or tuple values.
• The between operator for ranges of values.

2. Example: Find account number of accounts with balances between $90,000 and $100,000.
select account#
from account
where balance between 90000 and 100000