[Solved]Average Gpa Courses Student Victoria Hanson Taken Management Department Query Return Stude Q37254401

SQL Queries Needed:

4 Tables Given:

The average GPA of all the courses that the student Victoria Hanson has taken from the Management department. The query should return student name, department, and the average GPA. The average GPA of all the courses that the student Amy Earhart has taken in her major. The query should return student name, major, average GPA of all courses that she has taken in her major. Student’s name, student’s minor, course name, department, percent score, and GPA for the course where the student Sonia Hatfield got the lowest percent score of all the courses she took in her minor. If there is a tie, then the query should return the required information for all courses in her minor which are tied for the lowest percent score Student name, Major, Course name, department, GPA, professor name, and professor contact number of all courses taken in the student’s major where the student Bill Reilly got a 4.0 The department and the “departmental average GPA” for the student John Halber where the departmental average GPA is the lowest among all the departmental average GPAS. The departmental average GPA for a given student is defined as the average GPA of all the courses the student took from that department. The final query should return the student name, department name and the departmental average GPA for the department where the student John Halber got the lowest departmental average GPA. Courses tt CourseID nvarchar (50) [Course Name] nvarchar (MAX) [Course Description] nvarchar (MAX) Department nvarchar (50) PRIMARY KEY CourseID CoursesTaken t StudentID nvarchar (50) CourseID nvarchar (50) [Semester End Date] date [Professor SSN] nvarchar (50) [Percent Score] int GPA float Department nvarchar (50) PRIMARY KEY (StudentID, CourseID, Semester End Date]) Professor Information t SSN nvarchar (50) Name nvarchar (50) Address nvarchar (MAX) [Contact Number] nvarchar (50) [Date Joined USD] date PRIMARY KEY SSN Student Information t StudentID nvarchar (50) Name nvarchar (50) Address nvarchar (MAX) Major nvarchar (50) Minor nvarchar (50) [Undergraduate Standing] nvarchar (50) [Expected Graduation Date] date PRIMARY KEY StudentID Show transcribed image text The average GPA of all the courses that the student Victoria Hanson has taken from the Management department. The query should return student name, department, and the average GPA. The average GPA of all the courses that the student Amy Earhart has taken in her major. The query should return student name, major, average GPA of all courses that she has taken in her major. Student’s name, student’s minor, course name, department, percent score, and GPA for the course where the student Sonia Hatfield got the lowest percent score of all the courses she took in her minor. If there is a tie, then the query should return the required information for all courses in her minor which are tied for the lowest percent score Student name, Major, Course name, department, GPA, professor name, and professor contact number of all courses taken in the student’s major where the student Bill Reilly got a 4.0 The department and the “departmental average GPA” for the student John Halber where the departmental average GPA is the lowest among all the departmental average GPAS. The departmental average GPA for a given student is defined as the average GPA of all the courses the student took from that department. The final query should return the student name, department name and the departmental average GPA for the department where the student John Halber got the lowest departmental average GPA.
Courses tt CourseID nvarchar (50) [Course Name] nvarchar (MAX) [Course Description] nvarchar (MAX) Department nvarchar (50) PRIMARY KEY CourseID CoursesTaken t StudentID nvarchar (50) CourseID nvarchar (50) [Semester End Date] date [Professor SSN] nvarchar (50) [Percent Score] int GPA float Department nvarchar (50) PRIMARY KEY (StudentID, CourseID, Semester End Date]) Professor Information t SSN nvarchar (50) Name nvarchar (50) Address nvarchar (MAX) [Contact Number] nvarchar (50) [Date Joined USD] date PRIMARY KEY SSN Student Information t StudentID nvarchar (50) Name nvarchar (50) Address nvarchar (MAX) Major nvarchar (50) Minor nvarchar (50) [Undergraduate Standing] nvarchar (50) [Expected Graduation Date] date PRIMARY KEY StudentID

Expert Answer

---

Answer to The average GPA of all the courses that the student Victoria Hanson has taken from the Management department. The query … . . .