Employee Management System

Tables: Employees, Departments, Salaries.

Tasks: Find 2nd highest salary, department-wise avg salary, employees without a manager.

SELECT DepartmentID, AVG(Salary) AS AvgSalary
FROM Employees
GROUP BY DepartmentID;