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;

Computer Science & Information Technology

You might also like to view...

Answer the following questions true (T) or false (F)

1. A recursively written method will usually run slower and use more storage than an equivalent iterative version. 2. A recursive method must never return a value.

Computer Science & Information Technology

A(n) Java program is not a stand-alone applicaiton, but instead runs in conjunction with a hosting program such as a Web browser.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

In the Outlook Web App, the Deleted Items folder is where Outlook moves emails that are considered questionable

Indicate whether the statement is true or false

Computer Science & Information Technology

PSK passphrases of fewer than 20 characters can be subject to ____ attacks.

A. DDoS B. QoS C. offline dictionary D. DoS

Computer Science & Information Technology