Neco 2022 Computer Studies Question 32
Practice objective / multiple choice question 32 from the 2022 Neco Computer Studies examination.
Consider the following two tables in a relational database. Students(StudentID, Name, DeptID): | StudentID | Name | DeptID | | 1 | Ada | 10 | | 2 | Bola | 20 | | 3 | Chidi | 10 | | 4 | Dara | 20 | | 5 | Efe | 30 | Enrollments(StudentID, CourseCode, Grade): | StudentID | CourseCode | Grade | | 1 | CS101 | 85 | | 1 | CS102 | 90 | | 2 | CS101 | 78 | | 2 | CS103 | 82 | | 3 | CS101 | 88 | | 3 | CS102 | 92 | | 4 | CS103 | 80 | | 4 | CS104 | 84 | | 5 | CS101 | 70 | | 5 | CS104 | 75 | Write an SQL query that returns the DeptID(s) with the highest average Grade across all its students and the corresponding average (rounded to two decimal places). Based on the data above, what DeptID and average are returned?
Answer Options
About This Question
This is Neco 2022 Computer Studies Question 32. It is one of the objective questions from the 2022 Neco Computer Studies examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.