Post #2609

✅ 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