Count by Department

Easy
group-by

SQL Editor

Output

Click "Run Code" to see results...