The where Clause

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