WHERE with Numeric Conditions

How can we return only employees whose salary meets a specific condition?

Beginner⏱ 2 Minutes⭐ 540 XP

🤔 THE QUESTION

How can we return only employees whose salary meets a specific condition?

💡 WHAT IS IT?

The WHERE clause with comparison operators (>=, <=, >, <, =) filters rows before returning results.

🎯 WHAT IS IT USED FOR?

Salary band filtering, age requirements, transaction amount thresholds, inventory alerts.

💻 EXAMPLE

SELECT name, salary
FROM employees
WHERE salary >= 75000;

Practice typing production-grade SQL code for WHERE with Numeric Conditions.