Subqueries & Nested Queries - Practice

Hands-On Practice

Exercises

• Exercise 1: Apply basic subqueries & nested queries concepts
• Exercise 2: Solve intermediate-level challenges
• Exercise 3: Build a mini-project using subqueries & nested queries
• Exercise 4: Debug and fix common issues

Practice: Subqueries & Nested Queries

-- Find employees earning above their department average
SELECT e.name, e.salary, e.department
FROM employees e
WHERE e.salary > (
  SELECT AVG(e2.salary)
  FROM employees e2
  WHERE e2.department = e.department
)
ORDER BY e.department, e.salary DESC;

Review Quiz