The Where Clause
Arithmetic (+-*/) /Comparative (><=,!=) Operators
WHERE cost * 2 >= 20
WHERE state != ‘CA’
Logical Operators (AND, OR, NOT)
Ranges (BETWEEN, NOT BETWEEN)
Lists (IN, NOT IN)
WHERE state NOT IN (‘CA’, ‘MD’, ‘NJ’)
Unknowns (IS NULL, IS NOT NULL)
Character Matches (LIKE, NOT LIKE)
WHERE au_lname LIKE (‘Gr%’) OR au_lname LIKE (‘_reen’)