ASSIGNMENT $2($SQL$)$

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

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

$$ Include screenshot of the code and the output. Start the code wthe $$show user$$

$$ Deliver one $.$sql file that contains the questions and the select statements.

Assessment Rubrics

Task Possible Points Comments

SELECT Statement $12$

$22$

$32$

$42$

$52$

Total Points $10$