1. For each student, list the student ID, student name, and his/her average enrollment grade. Only...

Transcribed Image Text:

1. For each student, list the student ID, student name, and his/her average enrollment grade. Only list those students who have an average enrollment grade which is greater than the average enrollment grade of all enrollments. Sort the output by student's average grade in ascending order. stuid stulastname / [PK] numeric (5) character varying (12) 567 Au 234 Wong 345 Lai 890 Fung 456 Poon 678 Au 876 Lee 901 Chau 789 Chow stufirstname character varying (12) Taiman Cindy Leon Joe Kenny Cindy Hoyan Joe Chris Average Grade numeric 3.1500000000000000 3.1500000000000000 3.2333333333333333 3.3000000000000000 3.3000000000000000 3.3333333333333333 3.4000000000000000 3.5000000000000000 3.8000000000000000 Student StulD StuFirstName StuLastName StuCity StuDept StuClass StuMentorID 123 Vicky SHATIN IS 124 Ricky MONGKOK FIN 234 Cindy JORDON IS 345 Leon Shatin IS 456 Kenny SHATIN FIN 567 Taiman SHATIN IS TAIWAI FIN ShaTIN FIN SHATIN IS SHATIN IS MONGKOK IS 678 Cindy 789 Chris 876 Hoyan 890 Joe 901 Joe Cheung Wong Lai Poon Au Au Chow Lee Fung Chau University Database DLB302 DLB302 WLB212 WLB207 DLB302 DLB301 WLB212 DLB705 DLB301 AAB707 Course CourseNo CrsDesc FINE300 FUNDAMENTALS OF FINANCE FINE450 PRINCIPLES OF INVESTMENTS FINE480 CORPORATE FINANCE ISB1320 FUNDAMENTALS OF PYTHON PROGRAMMING SYSTEMS ANALYSIS AND DESIGN ISB1460 ISB1470 BUSINESS DATA COMMUNICATIONS ISB1480 DATA MANAGEMENT FOR BUSINESS Wong CHAN Lai Lee Offering OfferNo Course No OffTerm OffYear OffLocation OffTime FacID OffDay ISB1320 SPRING 2023 1111 10:30 Mon 1234 10:30 198 Mon ISB1320 ISB1460 2222 13:30 Thu SUMMER 2022 SUMMER 2023 5555 FINE300 FALL 2021 5678 ISB1480 FALL 2021 8:30 765 Wed 10:30 198 Fri 15:30 654 Tue 5679 ISB1480 6666 FINE450 7777 FINE480 8888 ISB1320 9876 ISB1460 SPRING 2022 FALL 2021 SPRING 2022 Tue 10:30 987 13:30 765 Wed SUMMER 2023 13:30 654 Mon SPRING 2022 13:30 198 Thu Cheung Snape SO SR JR SR SR UR SO JR SR SR SO 198 765 765 198 765 198 765 543 543 654 654 Crs Units 2 3 3 2 3 3 3 Faculty FacID FacFirstName FacLastName FacCity FacDept FacSalary FacSupervisor FacHire Date 543 Mary MONGKOK IS 120000 2015-04-15 654 Leo 2014-05-01 198 Leo 2015-04-15 765 Fanny SHATIN IS SHATIN IS WANCHAI FIN Shatin IS SHATIN FIN 1997-04-11 876 Chris 2015-03-01 987 Micky 2012-02-29 70000 543 35000 654 65000 40000 75000 Enrollment OfferNo StulD EnrGrade 654 765 1234 123 3.3 1234 234 3.5 1234 345 3.2 1234 456 3.1 1234 567 3.8 1234 678 3.4 5555 123 3.2 5555 124 2.7 5678 123 0 5678 234 2.8 5678 345 3.3 5678 456 3.4 5678 567 2.6 5679 123 2 5679 124 3.7 5679 678 3.3 5679 789 3.8 5679 890 2.9 5679 901 3.1 6666 124 2.7 6666 234 3.1 6666 567 3.6 7777 124 2.3 7777 876 3.4 7777 890 3.7 7777 901 3.4 9876 124 3.5 9876 234 3.2 9876 345 3.2 9876 456 3.4 9876 567 2.6 9876 678 9876 901 ME 3.3 4 1. For each student, list the student ID, student name, and his/her average enrollment grade. Only list those students who have an average enrollment grade which is greater than the average enrollment grade of all enrollments. Sort the output by student's average grade in ascending order. stuid stulastname / [PK] numeric (5) character varying (12) 567 Au 234 Wong 345 Lai 890 Fung 456 Poon 678 Au 876 Lee 901 Chau 789 Chow stufirstname character varying (12) Taiman Cindy Leon Joe Kenny Cindy Hoyan Joe Chris Average Grade numeric 3.1500000000000000 3.1500000000000000 3.2333333333333333 3.3000000000000000 3.3000000000000000 3.3333333333333333 3.4000000000000000 3.5000000000000000 3.8000000000000000 Student StulD StuFirstName StuLastName StuCity StuDept StuClass StuMentorID 123 Vicky SHATIN IS 124 Ricky MONGKOK FIN 234 Cindy JORDON IS 345 Leon Shatin IS 456 Kenny SHATIN FIN 567 Taiman SHATIN IS TAIWAI FIN ShaTIN FIN SHATIN IS SHATIN IS MONGKOK IS 678 Cindy 789 Chris 876 Hoyan 890 Joe 901 Joe Cheung Wong Lai Poon Au Au Chow Lee Fung Chau University Database DLB302 DLB302 WLB212 WLB207 DLB302 DLB301 WLB212 DLB705 DLB301 AAB707 Course CourseNo CrsDesc FINE300 FUNDAMENTALS OF FINANCE FINE450 PRINCIPLES OF INVESTMENTS FINE480 CORPORATE FINANCE ISB1320 FUNDAMENTALS OF PYTHON PROGRAMMING SYSTEMS ANALYSIS AND DESIGN ISB1460 ISB1470 BUSINESS DATA COMMUNICATIONS ISB1480 DATA MANAGEMENT FOR BUSINESS Wong CHAN Lai Lee Offering OfferNo Course No OffTerm OffYear OffLocation OffTime FacID OffDay ISB1320 SPRING 2023 1111 10:30 Mon 1234 10:30 198 Mon ISB1320 ISB1460 2222 13:30 Thu SUMMER 2022 SUMMER 2023 5555 FINE300 FALL 2021 5678 ISB1480 FALL 2021 8:30 765 Wed 10:30 198 Fri 15:30 654 Tue 5679 ISB1480 6666 FINE450 7777 FINE480 8888 ISB1320 9876 ISB1460 SPRING 2022 FALL 2021 SPRING 2022 Tue 10:30 987 13:30 765 Wed SUMMER 2023 13:30 654 Mon SPRING 2022 13:30 198 Thu Cheung Snape SO SR JR SR SR UR SO JR SR SR SO 198 765 765 198 765 198 765 543 543 654 654 Crs Units 2 3 3 2 3 3 3 Faculty FacID FacFirstName FacLastName FacCity FacDept FacSalary FacSupervisor FacHire Date 543 Mary MONGKOK IS 120000 2015-04-15 654 Leo 2014-05-01 198 Leo 2015-04-15 765 Fanny SHATIN IS SHATIN IS WANCHAI FIN Shatin IS SHATIN FIN 1997-04-11 876 Chris 2015-03-01 987 Micky 2012-02-29 70000 543 35000 654 65000 40000 75000 Enrollment OfferNo StulD EnrGrade 654 765 1234 123 3.3 1234 234 3.5 1234 345 3.2 1234 456 3.1 1234 567 3.8 1234 678 3.4 5555 123 3.2 5555 124 2.7 5678 123 0 5678 234 2.8 5678 345 3.3 5678 456 3.4 5678 567 2.6 5679 123 2 5679 124 3.7 5679 678 3.3 5679 789 3.8 5679 890 2.9 5679 901 3.1 6666 124 2.7 6666 234 3.1 6666 567 3.6 7777 124 2.3 7777 876 3.4 7777 890 3.7 7777 901 3.4 9876 124 3.5 9876 234 3.2 9876 345 3.2 9876 456 3.4 9876 567 2.6 9876 678 9876 901 ME 3.3 4