Kizspy.me
subject name, and the highest exam score from the most recent exam attempt for each
subject. Sort the results in ascending order by student id.
Student ID Student First Name
Student Last Name Subject Name
FinalGrade
1
1
An
Nguyen
Abstract Algebra
9.2
2
1
An
Nguyen
Calculus
8.5
34569
3
1
An
Nguyen
Linear Algebra
8
2
Binh
Tran
Computer Organization and Architecture
8
2
Binh
Tran
Introduction to Computer Science
8.7
2
Binh
Tran
Programming Fundamentals
8.7
7
3
Chi
Le
Data Structures and Algorithms
8.3
8
3
Chi
Le
Database Systems
9.8
9
3
Chi
Le
Operating Systems
5.4
10
4
Dung
Pham
International Economics
6.2
11
5
Dham
Mathematine for Fannamine
21
Picture 6.1
Question 7:
[1 mark] Write a query to retrieve the department name and subject name with the highest
number of exams scoring below 5 for each subject, regardless of the number of attempts.
The result should includes all rows that have the same highest value.
Zoom
+ 93%
Close
