Guaranteed upvoting for answering correctly

dbo.Program dbo.Course Columns dbo.Student P Course_ID (PK, int, not null) Columns Course_Name (varchar(24), null) P Student_ID (PK, int, not null). Course_Semester (varchar(24), null) Student_Name (varchar(24), null) P Program_ID (FK, int, null) Student_Type (varchar(24), null) P Teacher_ID (FK, int, null) Giludent_Admission_Date (date, null) Student_GPA (numeric (3,2), null) dbo.Teacher Program_ID (FK, int, null) Columns ? Teacher_ID (PK, int, not null) Teacher_Name (varchar(24), null) Teacher_Salary (numeric (3,2), null) 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 on the same campus as this program. For example, if computer science program is taught on 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 on the Davis campus - Return the name of the teacher(s) who have the 3rd highest salary - For every student, return the difference between the student gpa and the average gpa of the students who were admitted 30 days before and 30 days after the admission date of the student - 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