(a) SELECT Name, Major FROM STUDENT WHERE NOT EXISTS (SELECT * FROM GRADE_REPORT WHERE StudentNumber = STUDENT.StudentNumber AND NOT(Grade='A'))
(b) SELECT Name, Major FROM STUDENT WHERE NOT EXISTS (SELECT * FROM GRADE_REPORT WHERE StudentNumber = STUDENT.StudentNumber AND Grade='A')
(a) SELECT employee.fname, employee.lname FROM employee WHERE employee.dno = (SELECT employee.dno FROM employee WHERE employee.salary = (SELECT MAX(employee.salary) FROM employee))
(b) SELECT employee.fname, employee.lname FROM employee WHERE employee.superssn IN (SELECT employee.ssn FROM employee WHERE employee.superssn = '888665555')
(c) SELECT employee.fname, employee.lname FROM employee WHERE employee.salary >= 10000 + (SELECT MIN(employee.salary) FROM employee)
