| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- -- start query 1 in stream 0 using template query61.tpl and seed 1930872976
- select promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100
- from
- (select sum(ss_ext_sales_price) promotions
- from store_sales
- ,store
- ,promotion
- ,date_dim
- ,customer
- ,customer_address
- ,item
- where ss_sold_date_sk = d_date_sk
- and ss_store_sk = s_store_sk
- and ss_promo_sk = p_promo_sk
- and ss_customer_sk= c_customer_sk
- and ca_address_sk = c_current_addr_sk
- and ss_item_sk = i_item_sk
- and ca_gmt_offset = -6
- and i_category = 'Sports'
- and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y')
- and s_gmt_offset = -6
- and d_year = 2001
- and d_moy = 12) promotional_sales,
- (select sum(ss_ext_sales_price) total
- from store_sales
- ,store
- ,date_dim
- ,customer
- ,customer_address
- ,item
- where ss_sold_date_sk = d_date_sk
- and ss_store_sk = s_store_sk
- and ss_customer_sk= c_customer_sk
- and ca_address_sk = c_current_addr_sk
- and ss_item_sk = i_item_sk
- and ca_gmt_offset = -6
- and i_category = 'Sports'
- and s_gmt_offset = -6
- and d_year = 2001
- and d_moy = 12) all_sales
- order by promotions, total
- limit 100;
- -- end query 1 in stream 0 using template query61.tpl
|
