✅ SQL Aggregate Functions Questions with Answers Part-2 🚀📊

🔎 Q1. Find departments where the average salary is greater than 70,000.
🗂️ Table: "employees(emp_id, name, department_id, salary)"

✅ Answer:

SELECT department_id, AVG(salary) AS avg_salary
FROM employees
GROUP BY department_id
HAVING AVG(salary) > 70000;

🔎 Q2. Count employees in each department having more than 5 employees.
🗂️ Table: "employees(emp_id, name, department_id)"

✅ Answer:

SELECT department_id, COUNT(*) AS total_employees
FROM employees
GROUP BY department_id
HAVING COUNT(*) > 5;

🔎 Q3. Find the department with the highest total salary.
🗂️ Table: "employees(emp_id, department_id, salary)"

✅ Answer:

SELECT department_id
FROM employees
GROUP BY department_id
ORDER BY SUM(salary) DESC
LIMIT 1;

🔎 Q4. Get departments where the minimum salary is greater than 30,000.
🗂️ Table: "employees(emp_id, department_id, salary)"

✅ Answer:

SELECT department_id, MIN(salary) AS min_salary
FROM employees
GROUP BY department_id
HAVING MIN(salary) > 30000;

🔎 Q5. Find the difference between highest and lowest salary in each department.
🗂️ Table: "employees(emp_id, department_id, salary)"

✅ Answer:

SELECT department_id, MAX(salary) - MIN(salary) AS salary_difference
FROM employees
GROUP BY department_id;

Double Tap ♥️ For More