                                                                                                                                                                                                                                                                                                                                                                                                                                          QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                                          
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=887785.12..887785.19 rows=26 width=245)
   ->  Sort  (cost=887785.12..887785.19 rows=26 width=245)
         Sort Key: store.s_store_name, store.s_store_id, (sum(CASE WHEN (date_dim.d_day_name = 'Sunday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END)), (sum(CASE WHEN (date_dim.d_day_name = 'Monday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END)), (sum(CASE WHEN (date_dim.d_day_name = 'Tuesday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END)), (sum(CASE WHEN (date_dim.d_day_name = 'Wednesday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END)), (sum(CASE WHEN (date_dim.d_day_name = 'Thursday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END)), (sum(CASE WHEN (date_dim.d_day_name = 'Friday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END)), (sum(CASE WHEN (date_dim.d_day_name = 'Saturday'::bpchar) THEN store_sales.ss_sales_price ELSE NULL::numeric END))
         ->  GroupAggregate  (cost=886151.46..887784.51 rows=26 width=245)
               Group Key: store.s_store_name, store.s_store_id
               ->  Sort  (cost=886151.46..886247.48 rows=38408 width=37)
                     Sort Key: store.s_store_name, store.s_store_id
                     ->  Hash Join  (cost=2329.30..883226.86 rows=38408 width=37)
                           Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                           ->  Hash Join  (cost=2322.65..882847.36 rows=136613 width=20)
                                 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=14)
                                 ->  Hash  (cost=2318.11..2318.11 rows=363 width=14)
                                       ->  Seq Scan on date_dim  (cost=0.00..2318.11 rows=363 width=14)
                                             Filter: (d_year = 2000)
                           ->  Hash  (cost=6.28..6.28 rows=30 width=25)
                                 ->  Seq Scan on store  (cost=0.00..6.28 rows=30 width=25)
                                       Filter: (s_gmt_offset = '-5'::numeric)
(18 rows)

