Summing a COUNT Aggregate SQL Function
The following code snippet shows a small example of how you can sum the result of a count aggregate function. select sum(studentcount) as TotalCountfrom( SELECT count(s.studentname) as studentcount, s.studentname as