1. Scalar Subqueries: Definition: A scalar subquery returns a single value (one row, one column). Usage: They can be used anywhere a single value is expected, such as in WHERE clauses, SELECT lists, or HAVING clauses. Example: SQL SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary > ( SELECT AVG (salary) FROM employees); Explanation: The inner subquery (SELECT AVG(salary) FROM employees) calculates the average salary, which is a single value. The outer query then compares each employee's salary to this average. 2. Multiple-Row Subqueries: Definition: These subqueries return multiple rows (typically one column). Usage: They are used with operators like IN , NOT IN , ANY , ALL . Examples: Using IN : SQL SELECT employee_id, first_name, last_name FROM employees WHERE department_id IN ( SELECT department_id FROM departments WHERE location = 'New York' ); Explanation: The subquery returns a list...