Produce a report of the total hours worked by each employee, arranged in order of department number and within department, alphabetically by employee surname.

What will be an ideal response?

SELECT e.lName, e.fName, hoursWorked
FROM WorksOn w, Employee e, Department d
WHERE e.deptNo = d.deptNo AND e.empNo = w.empNo
ORDER BY d.deptNo, e.lName;