Compound Search Conditions in the WHERE Clause

Using comparison operators such as greater than (>), greater than or equal (>=), less than or equal (<=), and not equal (<>) with AND and OR creates more complex search conditions.

Qualifying the List

To list all employees born before March 3, 1964, but exclude the employee named Whitney:

SELECT Surname, BirthDate
FROM Employees
WHERE BirthDate < '1964-3-3'
AND Surname <> 'Whitney'

Surname	BirthDate
Cobb	1960-12-04
Jordan	1951-12-13
Breault	1947-05-13
Espinoza	1939-12-14
Dill	1963-07-19
Francis	1954-09-12
Shishov	1949-04-22
...	...