Answer
converting To SQL
Work Step by Step
select JobTitle
from JOB
where Dept = “PERSONNEL”
select EMPLOYEE.Name, JOB.Dept
from JOB, ASSIGNMENT, and EMPLOYEE
where (Job.Job = ASSIGNMENT.JobId) and
(ASSIGNMENT.EmplId EMPLOYEE.EmplID)
and (ASSIGNMENT.TermDate “*”)