Power of using Groups
Our Example Table
employeeID
employeeName
salary
department
Using GROUP BY to obtain information from the Employee table
GROUP BY to obtain information from the Employee tableDepartment Sizes
SELECT department, COUNT(*) AS employee_count
FROM Employees
GROUP BY department;department
employee_count
Total Salary of Departments
Department
Total Salary
Average Salary of Departments
Department
Average Salary
Minimum and Maximum Salaries of Each Department
Department
Min Salary
Max Salary
Last updated