By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 1 AS id, 2 AS value, 10 AS tire UNION ALL
SELECT 1, 1, 5 UNION ALL
SELECT 2, 3, 10
)
SELECT id, SUM(value), SUM(tire)
FROM yourTable
GROUP BY id, value WITH ROLLUP
ORDER BY -id DESC, SUM(value) DESC;
| id | SUM(value) | SUM(tire) |
|---|---|---|
| 1 | 3 | 15 |
| 1 | 2 | 10 |
| 1 | 1 | 5 |
| 2 | 3 | 10 |
| 2 | 3 | 10 |
| null | 6 | 25 |