I have code answer in the picture but when I check it in the website it\'s appea

Question

I have code answer in the picture but when I check it in the website it's appear to me yellow records which I don't want them how can I fix the code ??? The link below to check the code it should be over all 100% http://db.grussell.org/sql/interface.cgi?tn=Tutorial%203&qn=3
select DISTINCT e.surname, e. forenames from employee e, jobhistoryj where e.empno in (select distinct (h. empno) from jobhistory h where h.enddate between '01-JAN-1988' AND '31-DEC-1988) and j.enddate is not null here ce ie not n198 D 3- 986: SURNAME FORENAMES Roberts Robert Murray James Brownlie Matthew Allen Ester Robertson David Andrew Robinson Allan Wright Audrey Mary GordonMark

Explanation / Answer

add the solution in SQL function correctly:

select DISTINCT e.surname, e.forenames
from employee e, jobhistory j
where e.empno in (select distinct (h.empno) from jobhistory h where h.enddate between '01-JAN-1988' AND '31-DEC-1988') AND e.dob between '01-JAN-1950' AND '31-DEC-1959' and e.depno = 3

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.