USE ORACLE SQL PLUS.
Write queries using the Faculty, Student, Courses, Offering and Enrollment tables. Print out screenshots of the data in each table and the screenshots of running your queries.
1. List the number of courses being offered by term.
2. List the supervisors of all the faculties who are teaching a course in 'Fall 2015'.
3. Find the year when maximum number of faculty were hired.
4. List the number of courses (not offerings) taught in 2006 by faculty rank and department excluding the ones with zero courses taught.
5. List average hire year for faculty by supervisor
6. List maximum student gpa for each offering
Attachment:- NAME.zip