>Select customer.name, customer.code, COUNT(*), SUM(ord_tot - vat) AS value, >SUM(IIF(orders.o_type $ 'ABCDPS', 1, 0)) AS paid, SUM(IIF(orders.o_type > $ 'ABCDPS', 0, 1)) AS unpaid, SUM(orders.adw) AS s_adw, SUM(carriage) AS s_carr, SUM(vat) AS s_vat FROM ORDERS,CUSTOMER WHERE orders.ent_date< > (entdate) AND BETWEEN(orders.fun_date, (f_start), (f_end)) AND customer.code = orders.customer AND customer.custgroup = what INTO CURSOR T1>