select c.college_name 'College-Name',d.degree 'Abschluss',count(d.employee_id) 'Anzahl'
from colleges c,degrees d
where c.college_code=d.college_code
group by c.college_name,d.degree
go