text: select
  	cntrycode,
  	count(*) as numcust,
  	sum(c_acctbal) as totacctbal
  from
  	(
  		select
  			substring(c_phone from 1 for 2) as cntrycode,
  			c_acctbal
  		from
  			customer
  		where
  			substring(c_phone from 1 for 2) in
  				('20', '32', '44', '33', '29', '22', '31')
  			and c_acctbal > (
  				select
  					avg(c_acctbal)
  				from
  					customer
  				where
  					c_acctbal > 0.00
  					and substring(c_phone from 1 for 2) in
  						('20', '32', '44', '33', '29', '22', '31')
  			)
  			and not exists (
  				select
  					*
  				from
  					orders
  				where
  					o_custkey = c_custkey
  			)
  	) as custsale
  group by
  	cntrycode
  order by
  	cntrycode;
  