1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
-- start query 1 in stream 0 using template query28.tpl and seed 444293455
select *
from (select avg(ss_list_price) B1_LP
,count(ss_list_price) B1_CNT
,count(distinct ss_list_price) B1_CNTD
from store_sales
where ss_quantity between 0 and 5
and (ss_list_price between 73 and 73+10
or ss_coupon_amt between 7826 and 7826+1000
or ss_wholesale_cost between 70 and 70+20)) B1,
(select avg(ss_list_price) B2_LP
,count(ss_list_price) B2_CNT
,count(distinct ss_list_price) B2_CNTD
from store_sales
where ss_quantity between 6 and 10
and (ss_list_price between 152 and 152+10
or ss_coupon_amt between 2196 and 2196+1000
or ss_wholesale_cost between 56 and 56+20)) B2,
(select avg(ss_list_price) B3_LP
,count(ss_list_price) B3_CNT
,count(distinct ss_list_price) B3_CNTD
from store_sales
where ss_quantity between 11 and 15
and (ss_list_price between 53 and 53+10
or ss_coupon_amt between 3430 and 3430+1000
or ss_wholesale_cost between 13 and 13+20)) B3,
(select avg(ss_list_price) B4_LP
,count(ss_list_price) B4_CNT
,count(distinct ss_list_price) B4_CNTD
from store_sales
where ss_quantity between 16 and 20
and (ss_list_price between 182 and 182+10
or ss_coupon_amt between 3262 and 3262+1000
or ss_wholesale_cost between 20 and 20+20)) B4,
(select avg(ss_list_price) B5_LP
,count(ss_list_price) B5_CNT
,count(distinct ss_list_price) B5_CNTD
from store_sales
where ss_quantity between 21 and 25
and (ss_list_price between 85 and 85+10
or ss_coupon_amt between 3310 and 3310+1000
or ss_wholesale_cost between 37 and 37+20)) B5,
(select avg(ss_list_price) B6_LP
,count(ss_list_price) B6_CNT
,count(distinct ss_list_price) B6_CNTD
from store_sales
where ss_quantity between 26 and 30
and (ss_list_price between 180 and 180+10
or ss_coupon_amt between 12592 and 12592+1000
or ss_wholesale_cost between 22 and 22+20)) B6
limit 100;
-- end query 1 in stream 0 using template query28.tpl
|
