Database: company_projects
Question: What is the total number of projects handled by each department?
SQL: SELECT department_id, COUNT(project_id) AS total_projects FROM projects GROUP BY department_id