Example 5.17.2 The next select construct determines the average grade and
the number of courses taken by every student and sorts the results in ascending
order on the student number:
select stno, avg(grade) as average,
count(cno) as ncourses
from GRADES
group by stno
order by stno;
We obtain the result: