clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601421 fiddles created (47998 in the last week).

create table sales ( order_num INT, total_price float )
 hidden batch(es)


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);
 hidden batch(es)


select * from sales;
order_num total_price
11077 26
11077 31
11077 30
11077 17
10962 792
10962 324
10962 656
 hidden batch(es)


select order_num , SUM(total_price) from sales group by order_num;
order_num SUM(total_price)
10962 1772
11077 104
 hidden batch(es)