MySQL 5.7

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

create table sales
(
 order_num INT,
 total_price float
)
insert into sales VALUES(11077, 26.00);
insert into sales VALUES(11077, 31.00);
insert into sales VALUES(11077, 30.00);
insert into sales VALUES(11077, 17.00);
insert into sales VALUES(10962, 792.00);
insert into sales VALUES(10962, 324.00);
insert into sales VALUES(10962, 656.00);
select * from sales;


order_num
total_price


11077
26

11077
31

11077
30

11077
17

10962
792

10962
324

10962
656


select order_num , SUM(total_price)
from sales
group by order_num;


order_num
SUM(total_price)


10962
1772

11077
104