Problem 5.6
a) SELECT Name, Major FROM STUDENT WHERE NOT EXISTS(SELECT * FROM GRADE_REPORT WHERE Student_number = STUDENT.Student_number AND NOT(GRADE = ‘A’));
b.SELECT Name, Major FROM STUDENT WHERE EXISTS((SELECT * FROM GRADE_REPORT AS R, STUDENT AS S WHERE R.Student_number = S.Student_number) EXCEPT (SELECT Student_number FROM GRADE_REPORT WHERE Grade = ‘A’));
Problem 5.7
a) SELECT LNAME FROM employee WHERE DNO=(SELECT DNO FROM employee WHERE SALARY = (SELECT MAX(SALARY) FROM employee));
b)SELECT LNAME FROM employee WHERE SUPERSSN IN (SELECT SSN FROM employee WHERE SUPERSSN=’888665555′);
Fildena extra power 150 for sale
c) SELECT LNAME FROM employee WHERE SALARY >= 10000+(SELECT MIN(SALARY) FROM employee);