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