Kizspy.me
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.
Student ID Student First Name
Student Last Name Subject Name
1
1
An
Nguyen
Abstract Algebra
FinalGrade
9.2
2
1
An
Nguyen
Calculus
8.5
3
1
An
Nguyen
Linear Algebra
8
4
2
Binh
Tran
Computer Organization and Architecture
8
5
2
Binh
Tran
Introduction to Computer Science
8.7
6
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
Pham
Mathamstine for Enanamine
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
