a
c
b
d
select name , skill from employee, employeeSkills where employee.employeeID = employeeSkills.employeeID;
select client.clientID, name from client left join assignment on client.clientID = assignment.clientID where employeeID is NULL;
select clientID, name from client where not exists (select * from assignment where assignment.clientID = client.clientID);