resources/tpcds-modifiedQueries/q19.sql

0001 -- start query 19 in stream 0 using template query19.tpl
0002 select
0003   i_brand_id brand_id,
0004   i_brand brand,
0005   i_manufact_id,
0006   i_manufact,
0007   sum(ss_ext_sales_price) ext_price
0008 from
0009   date_dim,
0010   store_sales,
0011   item,
0012   customer,
0013   customer_address,
0014   store
0015 where
0016   d_date_sk = ss_sold_date_sk
0017   and ss_item_sk = i_item_sk
0018   and i_manager_id = 7
0019   and d_moy = 11
0020   and d_year = 1999
0021   and ss_customer_sk = c_customer_sk
0022   and c_current_addr_sk = ca_address_sk
0023   and substr(ca_zip, 1, 5) <> substr(s_zip, 1, 5)
0024   and ss_store_sk = s_store_sk
0025   and ss_sold_date_sk between 2451484 and 2451513  -- partition key filter
0026 group by
0027   i_brand,
0028   i_brand_id,
0029   i_manufact_id,
0030   i_manufact
0031 order by
0032   ext_price desc,
0033   i_brand,
0034   i_brand_id,
0035   i_manufact_id,
0036   i_manufact
0037 limit 100
0038 -- end query 19 in stream 0 using template query19.tpl