SQL Programming Resources on Telegram: “✅ SQL Subquery Practice Questions with Answers

✅ SQL Subquery Practice Questions with Answers — Part 2 🧠🗂️

🔎 Q1. Find employees earning more than the average salary of their department.
🗂️ Table: "employees(emp_id, name, department_id, salary)"

✅ Answer:

SELECT name, department_id, salary
FROM employees e1
WHERE salary > (
    SELECT AVG(salary)
    FROM employees e2
    WHERE e1.department_id = e2.department_id
);

🔎 Q2. Get customers who never placed any order.
🗂️ Tables: "customers(customer_id, name)", "orders(order_id, customer_id)"

✅ Answer:

SELECT customer_id, name
FROM customers
WHERE customer_id NOT IN (
    SELECT customer_id
    FROM orders
);

🔎 Q3. Find the second highest salary from employees.
🗂️ Table: "employees(emp_id, name, salary)"

✅ Answer:

SELECT MAX(salary) AS second_highest_salary
FROM employees
WHERE salary < (
    SELECT MAX(salary)
    FROM employees
);

🔎 Q4. List products priced higher than the average product price.
🗂️ Table: "products(product_id, product_name, price)"

✅ Answer:

SELECT product_name, price
FROM products
WHERE price > (
    SELECT AVG(price)
    FROM products
);

🔎 Q5. Find employees who work in the same department as 'John'.
🗂️ Table: "employees(emp_id, name, department_id)"

✅ Answer:

SELECT name, department_id
FROM employees
WHERE department_id = (
    SELECT department_id
    FROM employees
    WHERE name = 'John'
);

Double Tap ♥️ For More