Your inner query:
Select Count(*) from department Dep, Doctor do
Where Dep.De_ID = Do.De_ID
Group by Dep.Name
Returns more than one row, because it is a GROUP BY query and that is what it is supposed to do!
But the outer query expects only one value, so you get an error.
Look at using
INSERT INTO SELECT Statement[
^] instead.