Kizspy.me
6 of 6
Paper No: 1
DepartmentID
DepartmentName
NumberOfStudents
1
Mathematics
11
2
Computer Science
13
Software Engineering 14
Economics
12
Physics
7
Chemistry
Biology
4
1
234567
1234567
Picture 5.1
Question 6:
[1 mark] Write a query to retrieve the student id, student first name, student last name,
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.
Zoom
Student ID Student First Name Student Last Name Subject Name
FinalGrade
+ 93%
Close
