1. Specify the following queries in SQL on the database schema in Figure 1.2 (below). Retrieve the names and major а. departments of all students who have a grade of A in all their courses. b....

Extracted text: 1. Specify the following queries in SQL on the database schema in Figure 1.2 (below). Retrieve the names and major а. departments of all 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 a grade of A in any of their courses. STUDENT Name Student_number Class Major Smith 17 CS Brown CS COURSE Course name Course number Credit hours Department Intro to Computer Science CS1310 4 CS Data Structures Discrete Mathematics Database CS3320 4 CS MATH2410 MATH CS3380 3 CS SECTION Section_identifier Course number MATH2410 Semester Year Instructor 85 Fall 07 King 92 CS1310 Fall 07 Anderson Spring Knuth CS3320 MATH24 10 CS1310 102 08 Chang Anderson 112 Fall 08 119 Fall 08 135 CS3380 Fall 08 Stone GRADE REPORT Student_number Section_identifier Grade 17 112 17 119 A 92 A 102 B 135 A PREREQUISITE Course number CS3380 Prerequisite number CS3320 Figure 1.2 A database that stores student and course Information. MATH2410 CS1310 CS3380 CS3320