Complete the following Oracle SQL Queries:

1. List the student ID and name of the student that has enrolled the most times. Arrange the list in alphabetical order.

2. List the names and phone numbers of instructors who teach students that live in same zipcode as their instructor.

3. Provide a list of names and cities of students and instructors that live in zipcode 10025. Identify each person's role as either "Student" or "Instructor". Sort the list by role, last name and first name.

4. Create a query that lists location, number of sections taught in that location and number of students enrolled in courses at that location. Sort by location.

5. Create a query that shows all of the individual grades for student 112 in section 95 and also the average of those grades. The individual grades should come first with the average at the bottom. List the grade type code and numeric grade. The average row should have a caption of, "Average for student 112".

PENDIX D STUDENT DATABASE SCHEMA PENDIX D STUDENT DATABASE SCHEMA