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 $3$ rd 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

Instructions

Deliver one squl file that contains the questions and the select statements.

Assessment Rubrics

Please note that you need to create these tables and insert some rows to test your queries. Please share all code

plus snapshots of all results even statements you used for creating tables, as pdf files. Same as the previous

assignment, both SQL file and pdf should be uploaded in the Slate.