Kizspy.me
1
Software Engineering
Data Structures and Algorithms 3
Picture 7.1
Question 8:
[1 mark] Write a query to get the list the students whose scholarships are equal to the
highest scholarships of students in the Mathematics department. The result should include
StudentID, StudentLastName, StudentFirstName
12345
StudentID
StudentLastName
StudentFirstName
9
Ngo
Khanh
17
Luu
Tam
32
Luu
Vinh
41
Van
Lan
59
Bao
Kiet
Picture 8.1
Question 9:
[0.5 mark] Create a procedure named proc_report to count students belonging to a
department.
Where @deptname varchar(50) is an input parameter, @result INT is an output parameter
of the procedure.
+ 93%
Zoom
Close
