DELETE FROM sb_databillshort where PERIOD like '2025-04%' and WH in and ZTYPE='Z02'select MBITNO as ITNO, Sum (MBAVAL) as 'QTY',MBWHLO AS WH from MVXJDTA.MITBAL where MBWHLO in and MBAVAL>0 and MBITNO like '100%' GROUP BY MBITNO,MBWHLO