MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.46


create table sale (region varchar(10), amount int);
insert into sale values ('north',10),('north',7),('south',9),('south',3);

Records: 4  Duplicates: 0  Warnings: 0


-- window functions arrived in MySQL 8.0
select region, amount
     , sum(amount) over (partition by region order by amount) as running
from sale
order by region, amount;


region
amount
running


north
7
7

north
10
17

south
3
3

south
9
12


-- so did common table expressions
with totals as (
  select region, sum(amount) as total from sale group by region
)
select * from totals order by total desc;


region
total


north
17

south
12