(0) You can use group by clause in this assignment. Based on this database answer the following questions. 6. Show the student (including major) with the highest GPA. 7. List classes taught by faculties/instructors that the faculty is proficient,i.e., ProficiencyRating=10 in the subject of the class/course. 8. Show the top student(s) (the one with the highest GPA) of each major. 9. List students who are taking a course(s) and its prerequisite(s) at the same time. 10. List the earliest class (in terms of starting time) of each instructor. 11.Find the department chair that teaches the highest number of classes among other department heads