select calsettrace(1);

select  cntrycode,  count(*) as numcust,  sum(c_acctbal) as totacctbal 
from  (   select    substr(c_phone, 1, 2) as cntrycode,    c_acctbal   
	from    v_customer   
	where    substr(c_phone, 1, 2) in ('13', '31', '23', '29', '30', '18', '17')    
	and c_acctbal > (     select      avg(c_acctbal)     
			from      v_customer     
			where      c_acctbal > 0.00      
			and substr(c_phone, 1, 2) in ('13', '31', '23', '29', '30', '18', '17'))
	and not exists (     select      *     
			from      v_orders     
			where      o_custkey = c_custkey    )  
	) custsale 
group by  cntrycode 
order by  cntrycode;

select calgettrace() into @trace;
call customerColumnsTouched(@trace);
call ordersColumnsTouched(@trace);
call eliminatedBlocksGE(887);
