EXPLAIN select c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice, sum(l_quantity) from customer, orders, lineitem where o_orderkey in ( select l_orderkey from lineitem group by l_orderkey having sum(l_quantity) > 314 ) and c_custkey = o_custkey and o_orderkey = l_orderkey group by c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice order by o_totalprice desc, o_orderdate LIMIT 100;
                  plan                   
-----------------------------------------
                  sort                  
                                        
                 groupby                
                                        
                  join                  
                  hash                  
                                        
            join               tablescan
            indexnl            lineitem 
                                        
    rightsemijoin    tablescan          
    hash             customer           
                                        
  select   tablescan                    
           orders                       
  groupby                               
                                        
 tablescan                              
 lineitem                               
(19 rows)