For example, 300 students selection, have selected courses SC and course definition table COURSE:
Select course.cname, count (*) as numberid * = course.courseIdgroup by course.cname
RESULTS: Generation (course name, number of courses) record sets as follows: NULL 25 mathematics 135 language 140
