MariaDB 10.2

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

select version();

version()

10.2.44-MariaDB-10.2.44+maria~stretch-log

-- window functions and CTEs both arrived in MariaDB 10.2
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

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

-- CHECK constraints became enforced in 10.2 too
create table positive (x int check (x > 0));
insert into positive values (1);
select * from positive;

x

1