EXPLAIN select c_count, count(*) as custdist from ( select c_custkey, count(o_orderkey) from customer left outer join orders on c_custkey = o_custkey and o_comment not like '%express%accounts%' group by c_custkey ) as c_orders (c_custkey, c_count) group by c_count order by custdist desc, c_count desc;
        plan         
---------------------
        sort        
                    
       groupby      
                    
      groupjoin     
                    
 tablescan tablescan
 customer  orders   
(8 rows)