                                                               QUERY PLAN                                                               
----------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=908714.76..908715.01 rows=100 width=152)
   ->  Sort  (cost=908714.76..908727.18 rows=4967 width=152)
         Sort Key: customer.c_last_name, customer.c_first_name, (substr((store.s_city)::text, 1, 30)), (sum(store_sales.ss_net_profit))
         ->  Nested Loop  (cost=883772.35..908524.93 rows=4967 width=152)
               ->  GroupAggregate  (cost=883771.93..883933.36 rows=4967 width=86)
                     Group Key: store_sales.ss_ticket_number, store_sales.ss_customer_sk, store_sales.ss_addr_sk, store.s_city
                     ->  Sort  (cost=883771.93..883784.35 rows=4967 width=31)
                           Sort Key: store_sales.ss_ticket_number, store_sales.ss_customer_sk, store_sales.ss_addr_sk, store.s_city
                           ->  Hash Join  (cost=2771.71..883467.00 rows=4967 width=31)
                                 Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                                 ->  Hash Join  (cost=2764.01..883443.91 rows=5639 width=25)
                                       Hash Cond: (store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk)
                                       ->  Hash Join  (cost=2594.01..883118.72 rows=59086 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=157 width=4)
                                                   ->  Seq Scan on date_dim  (cost=0.00..2592.05 rows=157 width=4)
                                                         Filter: ((d_dow = 1) AND (d_year = ANY ('{1999,2000,2001}'::integer[])))
                                       ->  Hash  (cost=161.00..161.00 rows=720 width=4)
                                             ->  Seq Scan on household_demographics  (cost=0.00..161.00 rows=720 width=4)
                                                   Filter: ((hd_dep_count = 0) OR (hd_vehicle_count > 4))
                                 ->  Hash  (cost=6.53..6.53 rows=94 width=14)
                                       ->  Seq Scan on store  (cost=0.00..6.53 rows=94 width=14)
                                             Filter: ((s_number_employees >= 200) AND (s_number_employees <= 295))
               ->  Index Scan using customer_pkey on customer  (cost=0.42..4.94 rows=1 width=56)
                     Index Cond: (c_customer_sk = store_sales.ss_customer_sk)
(26 rows)

