Problem 5.6

http://takillakkta.org/malinovskiy/melenyk/2404 a) SELECT Name, Major FROM STUDENT WHERE NOT EXISTS(SELECT * FROM GRADE_REPORT WHERE Student_number = STUDENT.Student_number AND NOT(GRADE = ‘A’));

explanation 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

braunschweig kennenlernen a) SELECT LNAME FROM employee WHERE DNO=(SELECT DNO FROM employee WHERE SALARY = (SELECT MAX(SALARY) FROM employee));

http://marjodesign.com/?korol=forum-rencontre-vietnamienne&84a=03

http://marjodesign.com/?korol=rencontre-entre-joueur-de-wow&db8=df b)SELECT LNAME FROM employee WHERE SUPERSSN IN (SELECT SSN FROM employee WHERE SUPERSSN=’888665555′);

modalert uk pharmacy

c) SELECT LNAME FROM employee WHERE SALARY >= 10000+(SELECT MIN(SALARY) FROM employee);