EXPLAIN select s_name, s_address from supplier, nation where s_suppkey in ( select distinct (ps_suppkey) from partsupp, part where ps_partkey=p_partkey and p_name like 'misty%' and ps_availqty > ( select 0.5 * sum(l_quantity) from lineitem where l_partkey = ps_partkey and l_suppkey = ps_suppkey and l_shipdate >= '1996-01-01' and l_shipdate < date '1996-01-01' + interval '1 year' ) ) and s_nationkey = n_nationkey and n_name = 'ROMANIA' order by s_name;
                        plan                         
-----------------------------------------------------
                        sort                        
                                                    
                    leftsemijoin                    
                    hash                            
                                                    
        join                     groupby            
        hash                                        
                                  join              
 tablescan tablescan              hash              
 nation    supplier                                 
                             join            map    
                             hash                   
                                           groupby  
                     tablescan earlyprobe           
                     part                 earlyprobe
                               tablescan           
                               partsupp  tablescan
                                          lineitem 
(18 rows)