]>
Commit | Line | Data |
---|---|---|
aee94f69 TL |
1 | -- start query 1 in stream 0 using template query26.tpl and seed 1930872976 |
2 | select i_item_id, | |
3 | avg(cs_quantity) agg1, | |
4 | avg(cs_list_price) agg2, | |
5 | avg(cs_coupon_amt) agg3, | |
6 | avg(cs_sales_price) agg4 | |
7 | from catalog_sales, customer_demographics, date_dim, item, promotion | |
8 | where cs_sold_date_sk = d_date_sk and | |
9 | cs_item_sk = i_item_sk and | |
10 | cs_bill_cdemo_sk = cd_demo_sk and | |
11 | cs_promo_sk = p_promo_sk and | |
12 | cd_gender = 'F' and | |
13 | cd_marital_status = 'S' and | |
14 | cd_education_status = 'College' and | |
15 | (p_channel_email = 'N' or p_channel_event = 'N') and | |
16 | d_year = 1998 | |
17 | group by i_item_id | |
18 | order by i_item_id | |
19 | limit 100; | |
20 | ||
21 | -- end query 1 in stream 0 using template query26.tpl |