SQL Developer Internship - Task 6: Subqueries and Nested Queries This repository contains my submission for the sixth SQL task, which focuses on using subqueries (or nested queries) to solve complex ...
1.Subqueries in SELECT Clause Use subqueries to compute values and display them alongside main results. SELECT name, (SELECT AVG(salary) FROM employees) AS avg_salary FROM employees; 2.Subqueries in ...