A school has 500+ students. Assume a student table has these three attributes: s id, name, and GPA. Write a SQL statement to show the average of the top 10 distinctive GPAs 1. 2. A relationship table Course Student has these three attributes: c id, s id, and score Show the class id (c id) and the maximum score for each class. The maximum score should be displayed from the highest to the lowest in order Join the Student table in Q1 to show the class ids and the student names in each class. The class id is displayed in ascending order while the name is in descending a. b. order 3. Given these two tables below, please answer the two sub-questions DEPARTMENTS Name DEPT ID EMPLOYEES Name EMP ID FIRST NAME LAST NAME JOB SALARY DEPT ID Null? NOT NULL NUMBER(4 Null? VARCHAR2(10 DEPT NAME VARCHAR2(10) DEPT LOC ID VARCHAR2(9) NUMBER(2) VARCHAR2(20 NUMBER NOT NULL NUMBER NUMBER(2) List the department name and the employee names who have below the department's average salary, but higher than the maximum average salary of all departments List the department name and the employee names who have the 5th maximum salary in the individual department.| a. b