]>
git.proxmox.com Git - ceph.git/blob - ceph/src/s3select/TPCDS/sample-queries-tpcds/query26.sql
1 -- start query 1 in stream 0 using template query26.tpl and seed 1930872976
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
13 cd_marital_status
= 'S' and
14 cd_education_status
= 'College' and
15 (p_channel_email
= 'N' or p_channel_event
= 'N') and
21 -- end query 1 in stream 0 using template query26.tpl