shahnazmshariff

SELECT EXTRACT(DAY FROM TO_DATE(final_date, 'YYYY-MM-DD')) INTO final_day;

shahnazmshariff

SELECT SUM(qty) FILTER (where type = 'domestic' and item = 'desk') AS desk_from_domestic,
       SUM(qty) FILTER (where type = 'domestic' and item = 'bat') as bat_from_domestic
FROM purchases