![subject](/tpl/images/cats/informatica.png)
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;
![ansver](/tpl/images/cats/User.png)
Answers: 2
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 12:30
What characteristic of long period comets suggest they come directly from the oort cloud?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 21:00
Kirk found a local community college with a two-year program and he is comparing the cost with that of an out-of-state two-year school. what is the expected total cost for one year at the local community college if kirk lives at home? what is the expected total cost for one year at the out-of-state school if kirk lives on campus?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 23:30
What are listed in the vertical columns across the top of the event editor? a. file names b. conditions c. check marks d. action types
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 02:50
Be sure to answer all parts. synthesize the following compound from benzene. a. b. c. d. e. f. reaction [1] conditions: a b c d e f reaction [1] product: draw structure reaction [2] conditions: a b c d e f reaction [2] product: draw structure reaction [3] conditions: a b c d e f reaction [3] product:
Answers: 3
You know the right answer?
Retrieve the names of employees who work on exactly one project that is controlled by their departme...
Questions
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:40
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:41
![question](/tpl/images/cats/geografiya.png)
Geography, 24.04.2020 08:41
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:41
![question](/tpl/images/cats/geografiya.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 24.04.2020 08:41
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/mat.png)