clear markdown feedback
≡
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36280 in the last week).
CREATE TABLE data(ID INT,cost_1 INT, quantity_1 INT, cost_2 INT, quantity_2 INT); INSERT INTO data VALUES (1,1,2,3,4), (2,3,5,7,9),(3,10,5,20,2);
✓
3 rows affected
 hidden batch(es)
SELECT ID, cost_1, quantity_1, cost_2, quantity_2, total_1,total_2, total_1 + total_2 AS total_3 FROM data ,LATERAL (SELECT cost_1 * quantity_1, cost_2 * quantity_2) AS s1(total_1,total_2);
id cost_1 quantity_1 cost_2 quantity_2 total_1 total_2 total_3
1 1 2 3 4 2 12 14
2 3 5 7 9 15 63 78
3 10 5 20 2 50 40 90
…
 hidden batch(es)