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;
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.
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)
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
PSK passphrases of fewer than 20 characters can be subject to ____ attacks.
A. DDoS B. QoS C. offline dictionary D. DoS