Gathering distinct department names and counting each

1

Closed as the solution was found

2

select department_name, count(*) as number_of_modules
from module
group by department_name

3

Thank you, this did pretty much exactly what I was looking for