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 ;
group by department,office INTO table mucurt