Poţi folosi pur şi simplu:

SELECT prefix, SUM(nr) AS total
FROM (
... select-ul tau (fara ORDER BY)...
) t
GROUP BY prefix
ORDER BY prefix, total

Răzvan