I'm on an Oracle 11g database.

Query:

```
SELECT s.id, s.grade_level, 
((1990+substr(sg.termid,1,2))||'-'||(1991+substr(sg.termid,1,2))) as  "School Year",
SUM(sg.earnedcrhrs) as "Credits"

FROM students s
JOIN storedgrades sg ON s.id = sg.studentid

WHERE s.schoolid = 109
AND s.id = '3466'
AND s.enroll_status = 0
AND sg.schoolid = 109

GROUP BY ROLLUP(s.id, s.grade_level, substr(sg.termid,1,2))
ORDER BY s.id, substr(sg.termid,1,2)

```

Output:

![enter image description here](https://i.stack.imgur.com/lPCbH.jpg)

Is there a way I can write my query such that either line #5 or line #6 is not produced? I need only a single subtotal per student (the ID column).