(a) What do you want to retrieve by the following query? select LNAME, FNAME, SALARY from employee where SALARY > some (select SALARY from employee where DNO = 5): (b) What do you want to retrieve by...

(a) What do you want to retrieve by the following query?<br>select<br>LNAME, FNAME, SALARY<br>from<br>employee<br>where<br>SALARY > some (select<br>SALARY<br>from<br>employee<br>where<br>DNO = 5):<br>(b) What do you want to retrieve by the following query?<br>select<br>FNAME, LNAME, SSN, dno<br>from<br>employee<br>where<br>not exists( select<br>from<br>WORKS_ON B<br>where<br>(B.PNO in (select<br>PNUMBER<br>from<br>project<br>where<br>DNUM = 5)<br>and not exists( select<br>from<br>works_on C<br>where<br>C.ESSN = SSN and C.PNO = B.PNO))):<br>

Extracted text: (a) What do you want to retrieve by the following query? select LNAME, FNAME, SALARY from employee where SALARY > some (select SALARY from employee where DNO = 5): (b) What do you want to retrieve by the following query? select FNAME, LNAME, SSN, dno from employee where not exists( select from WORKS_ON B where (B.PNO in (select PNUMBER from project where DNUM = 5) and not exists( select from works_on C where C.ESSN = SSN and C.PNO = B.PNO))):

Jun 09, 2022

SOLUTION.PDF

(a) What do you want to retrieve by the following query? select LNAME, FNAME, SALARY from employee where SALARY > some (select SALARY from employee where DNO = 5): (b) What do you want to retrieve by...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment