Computers and Technology, 11.03.2020 05:40, unknownday7
Retrieve the names of employees who work on exactly one project that is controlled by their department. (It does not matter how many non-departmental projects they work on.) Also show the department name, and the project name and location. Show results in ascending alpha order (by last name and then first name).
Column Headings: FNAME LNAME DNAME PNAME PLOCATION
I currently have a list of names who work on projects controlled by their departments. But I am unsure on how to trim down the table so that it shows the employees who work on exactly one project controlled by there department. (ie, james borg and jennifer wallace). Values are subject to change, so i can not just do a direct comparison to their last names or something.
SQL Query I produced:
select distinct fname, lname, dname, pname, plocation
from works_on, project, employee, department
where works_on. pno = project. pnumber
and works_on. essn = employee. ssn
and project. dnum = employee. dno
and department. dnumber = employee. dno
order by lname, fname;
Answers: 2
Computers and Technology, 24.06.2019 13:20, sanaiajohnson56
In the insert table dialog box, you select the checkbox to create the first row as the header of the table.
Answers: 3
Retrieve the names of employees who work on exactly one project that is controlled by their departme...
Mathematics, 14.11.2020 22:50
Social Studies, 14.11.2020 22:50
Arts, 14.11.2020 22:50
Mathematics, 14.11.2020 22:50
English, 14.11.2020 23:00
Biology, 14.11.2020 23:00
Chemistry, 14.11.2020 23:00