WITH ROLLUP performs a "super-aggregate" operation.
WITH ROLLUP enables you to use a single query to get both the detailed results as well as the result of the given aggregate functions of all rows, as it is written in the SELECT clause on every single row selected.