Filtering Data with WHERE

Example

SELECT first_name, last_name
FROM employees
WHERE salary > 50000;

Explanation: This query selects only the first_name and last_name of employees whose salary is greater than 50,000. The WHERE clause restricts the results to those meeting the condition.