Given a relational schema: (in SQL )

1. List every two CourseNumber and their titles which ahve the same prerequisites.

2. List the name of every student and SSN who has completed all the courses he/she has taken and earned an A in each course i.e evert grade is an A or no null values.

3. List the name of every student and SSN who earned no A in any course.

4. List the name and major of evry student who has only taken courses that meet MW afternoon (12 or after)

5. List the name and major of every student who has taken all the courses that meet MW afternoon.

6. List the name and major of every student who has not taken any course that meets MW afternoon.

7. List every CourseNumber and Quarter which has the highest enrollment.

8. List every CourseNumber and CourseTitle which has the highest enorllment based on all quarters.

9. List the name and major of every student who has completed the highest number of units.

10. List every CourseTitle which is a prerequisite for the largest number of courses.

Given the following relational database schema: Student (SSN, Name, Major) Course (CourseNumber. PrerequisiteCourseNumber, Course Title, NumberUnits) Course (CouneNimbxs Penegiscember, Coune Section = (CourseNumber,Quarter, Room Number, DayTime), where DayTime is ofthe form MW 1:0-2:00PM Enrollment = (SSN CourseNumber Quarter, Grade)// Grade is either Null or a letter grade