You can specify the AND and OR logical operators in the WHERE clause to create more complex search conditions. For example, this statement selects employees who are in department 100 AND who have either a college degree OR at least 5 years of experience:
SELECT * FROM employee WHERE dept = 100 AND (edlev >= 16 OR yrsexp >= 5);