Use the attached schema for this question. ? For every program, return the program name, campus name, tuition fee and the Pnierag, tuition fee for the programs that are taught in in the same campus as this proc dm. 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"' highest salary k ? 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 ? Explain save point and rollback with example. [write this answer as a comment in .sql file]

Transcribed Image Text:

dbo.Campus BC Columns Campus ID (PK, int, not null) Campus Name (varchar(24), null) Campus Address (varchar(24), null) Campus City (varchar(12), null) dbo.Course Columns Course_ID (PK, int, not null) Course Name (varchar(24), null) Course Semester (varchar(24), null) Program ID (FK, int, null) Teacher ID (FK, int, null) dbo.Teacher Columns Teacher ID (PK, int, not null) Teacher Name (varchar(24), null) Teacher Salary (numeric(3.2), null) dbo.Program Columns Program ID (PK, int, not null) Program Name (varchar(24), null) Program Description (varchar(2000), null) Tuition Fees (numeric(7,2), null) Program Coordinator ID (FK, int, null) Campus ID (FK, int, null) dbo.Student Columns Student ID (PK, int, not null) Student Name (varchar(24), null) Student Type (varchar(24), null) Student Admission Date (date, null) Student GPA (numeric(3,2), null) Program ID (FK, int, null) dbo.Campus BC Columns Campus ID (PK, int, not null) Campus Name (varchar(24), null) Campus Address (varchar(24), null) Campus City (varchar(12), null) dbo.Course Columns Course_ID (PK, int, not null) Course Name (varchar(24), null) Course Semester (varchar(24), null) Program ID (FK, int, null) Teacher ID (FK, int, null) dbo.Teacher Columns Teacher ID (PK, int, not null) Teacher Name (varchar(24), null) Teacher Salary (numeric(3.2), null) dbo.Program Columns Program ID (PK, int, not null) Program Name (varchar(24), null) Program Description (varchar(2000), null) Tuition Fees (numeric(7,2), null) Program Coordinator ID (FK, int, null) Campus ID (FK, int, null) dbo.Student Columns Student ID (PK, int, not null) Student Name (varchar(24), null) Student Type (varchar(24), null) Student Admission Date (date, null) Student GPA (numeric(3,2), null) Program ID (FK, int, null)

Answer rating: 100% (QA)

SELECT PPPROGRAMNAME CCCAMPUSNAME PPTUITIONFEES GRPAVGFEES FROM CAMPUS CC PROGRAM PP SELECT CCAMPUSI... View the full answer