Combining Conditions

How can we filter employees using more than one condition?

Intermediate⏱ 2 Minutes⭐ 560 XP

🤔 THE QUESTION

How can we filter employees using more than one condition?

💡 WHAT IS IT?

The AND operator requires all specified predicates to evaluate to true for a row to be included in the result.

🎯 WHAT IS IT USED FOR?

Multi-criteria queries, high-earning department members, scoped date range filters.

💻 EXAMPLE

SELECT name, salary
FROM employees
WHERE department = 'Engineering'
AND salary > 80000;

Practice typing production-grade SQL code for Combining Conditions.