Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 3

-Specify the following queries in SQL on the database schema of Figure 1.2.
(a) Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their courses).
(b) Retrieve the names and major departments of all students who do not have any grade of A in any of their courses.