1️) Scalar Subquery in SELECT: SELECT e.emp_id, e.emp_name, e.salary, (SELECT ROUND(AVG(salary), 2) FROM employees WHERE dept_id = e.dept_id) AS dept_avg_salary FROM employees e; 2️) Correlated ...

Now that you've seen how subqueries work, it's time to get some practice writing them! Not all of the queries will require subqueries, but all will be a bit more complex and require some thought and ...