TIGRANE 4. 1
Question 5:
Write a query to display DepartmentCode, DepartmentName, NumberOfStudents corresponding to each department where NumberOfStudents is the number of distinct students who have enrollments in the semester 'Sp2019_B5' of each department. Display the results in ascending order of NumberOfStudents then in ascending order of DepartmentName for rows having the same NumberOfStudents as in the following figure.Note that NumberOfStudents = 0 if the corresponding department has no student who has enrollments in the semester 'Sp2019_B5'.
DepartmentCode
Al
DepartmentName
NumberOfStudents
0
0
2
Artificial Intelligence
BA
CS
Business Administration
Computer Science
MC
SE
Multimedia Communications 5
Software Engineering
Picture 5.1
9
1
2
3
4
5
Question 6:
Write a query to display studentld, studentName, NumberOfEnrollments of all students having the highest or the smallest number of enrollments (NumberOfEnrollments) as in the following figure. Note that the NumberOfEnrollments of each student is the number of all enrollments of the corresponding student.
Zoom
+ 100%
Close
