resources/tpcds-modifiedQueries/q55.sql

0001 -- start query 55 in stream 0 using template query55.tpl
0002 select
0003   i_brand_id brand_id,
0004   i_brand brand,
0005   sum(ss_ext_sales_price) ext_price
0006 from
0007   date_dim,
0008   store_sales,
0009   item
0010 where
0011   d_date_sk = ss_sold_date_sk
0012   and ss_item_sk = i_item_sk
0013   and i_manager_id = 48
0014   and d_moy = 11
0015   and d_year = 2001
0016   and ss_sold_date_sk between 2452215 and 2452244
0017 group by
0018   i_brand,
0019   i_brand_id
0020 order by
0021   ext_price desc,
0022   i_brand_id
0023 limit 100
0024 -- end query 55 in stream 0 using template query55.tpl