Hello,

Please I am trying to include a total row to a query that returns the count for specific columns but keep getting an sub-query error.

My syntax is as follows:

SELECT sequence, ID, term, program, course_code, COUNT(course_code) AS courseCount
FROM table
WHERE term in ([:term]) AND course-code = course_code
GROUP by sequence, ID, term, program, course_code
ORDER BY sequence;

This gives an output that has a courseCount column but when I try to do this:

SELECT sequence, ID, term, program, course_code, COUNT(course_code) AS courseCount, SUM(courseCount)
FROM table
WHERE term in ([:term]) AND course-code = course_code
GROUP by sequence, ID, term, program, course_code
ORDER BY sequence;

I get an error stating subquery cannot be used in the expression SUM(courseCount)