i need help to count again the same field as below
SELECT office , department,count(office) as total_cfil && and count(office) as sub-total where flg="1" and newfield have( total_cfil -sub-total) ;from new1 ;
groupby department,office INTOtable mucurt