The following code snippet shows a small example of how you can sum the result of a count aggregate function.
select sum(studentcount) as TotalCount
from
(
SELECT
count(s.studentname) as studentcount,
s.studentname as studentname
FROM [students] as s
group by s.studentname
order by count(s.studentname) desc
)a
Visit the DevX Tip Bank