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, 21.06.2019 16:00, trapqueenriz12
Ramon is graphing the function f(x) = 3(4)x. he begins by plotting the initial value. which graph represents his initial step?
Answers: 2
Computers and Technology, 23.06.2019 02:00, eila3601
As with any small island country, cuba has fewer natural resources than countries such as brazil. this affects their economy in that cuba a) exports only manufactured products. b) exports more products than it imports.. c) must import more products than it exports. d) has imposed trade barriers against the united states.
Answers: 3
Computers and Technology, 23.06.2019 07:50, kmart4062
Apython programming question: assume s is a string of lower case characters. write a program that prints the number of times the string 'bob' occurs in s. for example, if s = 'azcbobobegghakl', then your program should print number of times bob occurs is: 2
Answers: 3
Retrieve the names of employees who work on exactly one project that is controlled by their departme...
English, 07.09.2019 20:10
Mathematics, 07.09.2019 20:10
Computers and Technology, 07.09.2019 20:10
Mathematics, 07.09.2019 20:10
Mathematics, 07.09.2019 20:10
History, 07.09.2019 20:10