In turn, we can use the grouping values and the having clause to retain only
certain summary rows as in
select cno, empno, count(grade) as nogr,
grouping(cno) as c, grouping(empno) as e
from grades
group by cube(cno,empno)
having grouping(cno) = 1 or grouping(empno) = 1