show me the number of staff of all departments.
SELECT department_id,count ( staff_id )  FROM staff_department_assignments GROUP BY department_id ORDER BY count ( * ) 
number of staff in all departments refers to COUNT(staff_id); grouped by department refers to GROUP BY department_id;