select weekName,sumCount,deptID from weekList,
(select sum(menCount) sumCount,weekID,s.deptID 
from shift s,shiftDetail sd  
where sd.shiftID = s.id and s.deptID = 3  
group by weekID,s.deptID) b
where weekList.weekID = b.weekID