SQL • LESSON 05

Filtering with WHERE

Learn how to filter SQL results using the WHERE clause.

🟢 Beginner⏱ 2 Minutes⭐ 120 XP
🤔 THE QUESTION

How can we filter data using more than one condition?

💡 WHAT IS IT?

SQL lets us combine conditions so that a query can return only the rows that satisfy the required rules.

🎯 WHAT IS IT USED FOR?

It is useful when filtering real-world data using multiple requirements, such as department, salary, location, status, or date.

💻 EXAMPLE
SELECT *
FROM employees
WHERE department = 'IT'
AND salary > 50000;

Mission Brief

Practice filtering employee records using a SQL WHERE condition.

Objectives

  • ✓ SELECT
  • ✓ FROM
  • ✓ WHERE
  • ✓ Comparison operators
🚀 Start Mission