Please provide the solution asap.

Use the attached schema for this assignment - For every program, return the program name, campus name, tuition fee and the average tuition fee for the programs that are taught in in the same campus as this program. For example if computer science program is taught in Davis campus then I want you to return the program name, campus name, tuition fee of the program and the average tuition fee for all the programs that are taught in Davis campus. A program can have multiple records (rows) if it is taught in multiple campuses - Return the name of the student(s) who have the 4th lowest GPA - Find the average GPA of the 30 students who where admitted right before the admission date of a student and then compare the GPA of the student to the average GPA of these students. Do this for all the students - Teacher table is queried often using teacher name as the condition. Create an index that will improve the performance of this query. You need to choose the most appropriate index - Write SQL statement that will create student table as index organized table Instructions - Deliver one .sql file that contains the questions and the select statements. Assessment Rubrics