What is the method to merge `Select` and `Where`?

edit

In SQL, Select and Where can be merged by placing the conditions in the Where clause to filter the results of the Select statement.

For example, consider the following two separate SQL queries:

SELECT name, age 
FROM employees 
WHERE department = 'Sales';

SELECT name, age 
FROM employees 
WHERE salary > 50000;

These two queries can be merged using the AND or OR operator in the Where clause:

SELECT name, age 
FROM employees 
WHERE department = 'Sales' AND salary > 50000;

This will return only the employees who work in the Sales department and have a salary greater than 50000.