                                                                                   QUERY PLAN                                                                                    
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=933256.76..933257.01 rows=100 width=138)
   ->  Sort  (cost=933256.76..933301.58 rows=17926 width=138)
         Sort Key: customer.c_last_name, customer.c_first_name, current_addr.ca_city, dn.bought_city, dn.ss_ticket_number
         ->  Nested Loop  (cost=895257.33..932571.65 rows=17926 width=138)
               Join Filter: ((current_addr.ca_city)::text <> (dn.bought_city)::text)
               ->  Merge Join  (cost=895256.91..923612.53 rows=17955 width=133)
                     Merge Cond: (customer.c_customer_sk = dn.ss_customer_sk)
                     ->  Index Scan using customer_pkey on customer  (cost=0.42..26836.72 rows=500000 width=60)
                     ->  Sort  (cost=895256.48..895301.37 rows=17955 width=81)
                           Sort Key: dn.ss_customer_sk
                           ->  Subquery Scan on dn  (cost=893224.69..893987.77 rows=17955 width=81)
                                 ->  GroupAggregate  (cost=893224.69..893808.22 rows=17955 width=85)
                                       Group Key: store_sales.ss_ticket_number, store_sales.ss_customer_sk, store_sales.ss_addr_sk, customer_address.ca_city
                                       ->  Sort  (cost=893224.69..893269.57 rows=17955 width=30)
                                             Sort Key: store_sales.ss_ticket_number, store_sales.ss_customer_sk, store_sales.ss_addr_sk, customer_address.ca_city
                                             ->  Nested Loop  (cost=2787.36..891955.98 rows=17955 width=30)
                                                   ->  Hash Join  (cost=2786.94..883689.09 rows=18796 width=21)
                                                         Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                                                         ->  Hash Join  (cost=2779.37..883606.54 rows=27475 width=25)
                                                               Hash Cond: (store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk)
                                                               ->  Hash Join  (cost=2595.87..883120.58 rows=115161 width=29)
                                                                     Hash Cond: (store_sales.ss_sold_date_sk = date_dim.d_date_sk)
                                                                     ->  Seq Scan on store_sales  (cost=0.00..804917.92 rows=28800992 width=33)
                                                                     ->  Hash  (cost=2592.05..2592.05 rows=306 width=4)
                                                                           ->  Seq Scan on date_dim  (cost=0.00..2592.05 rows=306 width=4)
                                                                                 Filter: ((d_dow = ANY ('{6,0}'::integer[])) AND (d_year = ANY ('{1999,2000,2001}'::integer[])))
                                                               ->  Hash  (cost=161.00..161.00 rows=1800 width=4)
                                                                     ->  Seq Scan on household_demographics  (cost=0.00..161.00 rows=1800 width=4)
                                                                           Filter: ((hd_dep_count = 3) OR (hd_vehicle_count = 1))
                                                         ->  Hash  (cost=6.66..6.66 rows=73 width=4)
                                                               ->  Seq Scan on store  (cost=0.00..6.66 rows=73 width=4)
                                                                     Filter: ((s_city)::text = ANY ('{Midway,Fairview,Fairview,Midway,Fairview}'::text[]))
                                                   ->  Index Scan using customer_address_pkey on customer_address  (cost=0.42..0.44 rows=1 width=13)
                                                         Index Cond: (ca_address_sk = store_sales.ss_addr_sk)
               ->  Index Scan using customer_address_pkey on customer_address current_addr  (cost=0.42..0.49 rows=1 width=13)
                     Index Cond: (ca_address_sk = customer.c_current_addr_sk)
(36 rows)

