1 -- start query 1 in stream 0 using template query17.tpl and seed 1819994127
5 ,count(ss_quantity
) as store_sales_quantitycount
6 ,avg(ss_quantity
) as store_sales_quantityave
7 ,stddev_samp(ss_quantity
) as store_sales_quantitystdev
8 ,stddev_samp(ss_quantity
)/avg(ss_quantity
) as store_sales_quantitycov
9 ,count(sr_return_quantity
) as store_returns_quantitycount
10 ,avg(sr_return_quantity
) as store_returns_quantityave
11 ,stddev_samp(sr_return_quantity
) as store_returns_quantitystdev
12 ,stddev_samp(sr_return_quantity
)/avg(sr_return_quantity
) as store_returns_quantitycov
13 ,count(cs_quantity
) as catalog_sales_quantitycount
,avg(cs_quantity
) as catalog_sales_quantityave
14 ,stddev_samp(cs_quantity
) as catalog_sales_quantitystdev
15 ,stddev_samp(cs_quantity
)/avg(cs_quantity
) as catalog_sales_quantitycov
24 where d1.d_quarter_name
= '2000Q1'
25 and d1.d_date_sk
= ss_sold_date_sk
26 and i_item_sk
= ss_item_sk
27 and s_store_sk
= ss_store_sk
28 and ss_customer_sk
= sr_customer_sk
29 and ss_item_sk
= sr_item_sk
30 and ss_ticket_number
= sr_ticket_number
31 and sr_returned_date_sk
= d2.d_date_sk
32 and d2.d_quarter_name
in ('2000Q1','2000Q2','2000Q3')
33 and sr_customer_sk
= cs_bill_customer_sk
34 and sr_item_sk
= cs_item_sk
35 and cs_sold_date_sk
= d3.d_date_sk
36 and d3.d_quarter_name
in ('2000Q1','2000Q2','2000Q3')
45 -- end query 1 in stream 0 using template query17.tpl