]>
git.proxmox.com Git - ceph.git/blob - ceph/src/s3select/TPCDS/sample-queries-tpcds/query27.sql
1 -- start query 1 in stream 0 using template query27.tpl and seed 2017787633
3 s_state
, grouping(s_state
) g_state
,
5 avg(ss_list_price
) agg2
,
6 avg(ss_coupon_amt
) agg3
,
7 avg(ss_sales_price
) agg4
8 from store_sales
, customer_demographics
, date_dim
, store
, item
9 where ss_sold_date_sk
= d_date_sk
and
10 ss_item_sk
= i_item_sk
and
11 ss_store_sk
= s_store_sk
and
12 ss_cdemo_sk
= cd_demo_sk
and
14 cd_marital_status
= 'U' and
15 cd_education_status
= '2 yr Degree' and
17 s_state
in ('AL','IN', 'SC', 'NY', 'OH', 'FL')
18 group by rollup (i_item_id
, s_state
)
23 -- end query 1 in stream 0 using template query27.tpl