这样的SQL语句，如何样写更好

这样的SQL语句，怎么样写更好

SQL code

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) bwhere weekList.weekID = b.weekID