SELECt a.lecturerName, b.NumOfModulesFROM Lecturer a,(SELECt l.lecturerID, COUNT(moduleID) AS NumOfModules FROM Lecturer l , Teaches t WHERe l.lecturerID = t.lecturerID AND year = 2011 GROUP BY l.lecturerID) bWHERe a.lecturerID = b.lecturerID

SELECt a.lecturerName, b.NumOfModulesFROM Lecturer a,(SELECt l.lecturerID, COUNT(moduleID) AS NumOfModules FROM Lecturer l , Teaches t WHERe l.lecturerID = t.lecturerID AND year = 2011 GROUP BY l.lecturerID) bWHERe a.lecturerID = b.lecturerID