-- start query 8 in stream 0 using template query19.tpl
select  i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,
 	sum(ss_ext_sales_price) ext_price
 from bigdata_public_dataset.tpcds_10g.date_dim, bigdata_public_dataset.tpcds_10g.store_sales, bigdata_public_dataset.tpcds_10g.item,bigdata_public_dataset.tpcds_10g.customer,bigdata_public_dataset.tpcds_10g.customer_address,bigdata_public_dataset.tpcds_10g.store
 where d_date_sk = ss_sold_date_sk
   and ss_item_sk = i_item_sk
   and i_manager_id=18
   and d_moy=12
   and d_year=2002
   and ss_customer_sk = c_customer_sk 
   and c_current_addr_sk = ca_address_sk
   and substr(ca_zip,1,5) <> substr(s_zip,1,5) 
   and ss_store_sk = s_store_sk 
 group by i_brand
      ,i_brand_id
      ,i_manufact_id
      ,i_manufact
 order by ext_price desc
         ,i_brand
         ,i_brand_id
         ,i_manufact_id
         ,i_manufact
limit 100 ;

-- end query 8 in stream 0 using template query19.tpl
