select distinct cust, inv, part, qty, unit, (qty*weight)::numeric(8,2) as Wt, subtotal::numeric(8,0) as Total from inv_info where transdate between '2020-07-01' and '2020-07-31';