Postgres 13

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

select version();


version


PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit


create table sales(
txn_amt int,
txn_date_key numeric(8),
order_item_unit_status varchar(220)
);

Insert into sales values(1600,20190701,'DELIVERED');
Insert into sales values(1600,20190701,'DELIVERED');
Insert into sales values(1500,20210631,'RETURNED');
Insert into sales values(1500,20210631,'RETURNED');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

Select *, CASE WHEN order_item_unit_status ='DELIVERED'
THEN txn_amt ELSE 0 END as DELIVERED, 
CASE WHEN order_item_unit_status ='RETURNED'
THEN txn_amt ELSE 0 END as RETURNED
from sales


txn_amt
txn_date_key
order_item_unit_status
delivered
returned


1600
20190701
DELIVERED
1600
0

1600
20190701
DELIVERED
1600
0

1500
20210631
RETURNED
0
1500

1500
20210631
RETURNED
0
1500

txn_amt	txn_date_key	order_item_unit_status	delivered	returned
1600	20190701	DELIVERED	1600	0
1600	20190701	DELIVERED	1600	0
1500	20210631	RETURNED	0	1500
1500	20210631	RETURNED	0	1500