Answers
Quiz
Exercises
| | | A1:
|
select name, skill
from employee, employeeSkills
where employee.employeeID = employeeSkills.employeeID;
| | | | A2:
|
select client.clientID, name
from client left join assignment
on client.clientID = assignment.clientID
where employeeID is NULL;
| | | | A3:
|
select clientID, name
from client
where not exists
(select *
from assignment
where assignment.clientID = client.clientID);
|
|
