I have this answer below in pic, but when I check the answer in this link it\'s
ID: 3670486 • Letter: I
Question
I have this answer below in pic, but when I check the answer in this link it's not the write answer!! http://db.grussell.org/sql/interface.cgi?tn=Tutorial%203&qn=9 I have this answer below in pic, but when I check the answer in this link it's not the write answer!! http://db.grussell.org/sql/interface.cgi?tn=Tutorial%203&qn=9 I have this answer below in pic, but when I check the answer in this link it's not the write answer!! http://db.grussell.org/sql/interface.cgi?tn=Tutorial%203&qn=9 elect e.surname, e.forenames from Employee e, department s where e . DepNo= s.depno and e·surname e"forename 3 = 'Matthew'; 'Brownlie, and
Explanation / Answer
SELECT surname, forenames FROM employee WHERE depno = (SELECT depno FROM employee WHERE forename = 'Matthew' AND surname='Brownlie')