Examples

SELECT * FROM employees WHERE salary > 50000;
SELECT * FROM employees WHERE department = 'HR';

Multiple Conditions

SELECT * FROM employees WHERE department = 'HR' AND salary > 60000;