Write an SQL query: how many employees are in each department (table employee with columns: employee ID, name, age, department)?

sql SELECT department, COUNT(*) AS employee_count FROM employee GROUP BY department;

This query groups employees by department and counts the number of employees in each department.