| ==== |
| ---- QUERY: TPCDS-Q7 |
| select |
| i_item_id, |
| avg(ss_quantity) agg1, |
| avg(ss_list_price) agg2, |
| avg(ss_coupon_amt) agg3, |
| avg(ss_sales_price) agg4 |
| from |
| store_sales, |
| customer_demographics, |
| date_dim, |
| item, |
| promotion |
| where |
| ss_sold_date_sk = d_date_sk |
| and ss_item_sk = i_item_sk |
| and ss_cdemo_sk = cd_demo_sk |
| and ss_promo_sk = p_promo_sk |
| and cd_gender = 'M' |
| and cd_marital_status = 'S' |
| and cd_education_status = 'College' |
| and (p_channel_email = 'N' |
| or p_channel_event = 'N') |
| and d_year = 2000 |
| group by |
| i_item_id |
| order by |
| i_item_id |
| limit 100; |
| ---- RESULTS |
| 'AAAAAAAAAAACAAAA',17,13.15,7.70,1.97 |
| 'AAAAAAAAAAAEAAAA',99,123.44,0.00,44.43 |
| 'AAAAAAAAAABBAAAA',11,77.31,0.00,38.65 |
| 'AAAAAAAAAABEAAAA',35.5,18.90,0.00,4.85 |
| 'AAAAAAAAAACAAAAA',61,38.63,90.24,16.38 |
| 'AAAAAAAAAACCAAAA',10.5,83.46,0.00,30.02 |
| 'AAAAAAAAAADBAAAA',44,108.36,0.00,13.00 |
| 'AAAAAAAAAADCAAAA',54,59.29,0.00,34.98 |
| 'AAAAAAAAAADEAAAA',93,43.57,0.00,38.34 |
| 'AAAAAAAAAAEAAAAA',72,16.46,0.00,13.33 |
| 'AAAAAAAAAAEBAAAA',88,29.02,0.00,0.87 |
| 'AAAAAAAAAAEDAAAA',91,84.37,0.00,9.09 |
| 'AAAAAAAAAAFDAAAA',37,33.13,0.00,20.20 |
| 'AAAAAAAAAAGEAAAA',35,56.48,881.45,23.63 |
| 'AAAAAAAAAAHDAAAA',33,59.05,0.00,48.53 |
| 'AAAAAAAAAAICAAAA',68.5,108.73,166.78,69.22 |
| 'AAAAAAAAAAIDAAAA',76,97.19,0.00,43.73 |
| 'AAAAAAAAAAJCAAAA',30,47.55,0.00,30.43 |
| 'AAAAAAAAAAKBAAAA',59,55.08,0.00,17.07 |
| 'AAAAAAAAAAMBAAAA',74,10.39,0.00,8.62 |
| 'AAAAAAAAAAMCAAAA',86,24.10,0.41,0.48 |
| 'AAAAAAAAAANAAAAA',43,80.16,0.00,41.68 |
| 'AAAAAAAAAANBAAAA',28,112.27,0.00,57.25 |
| 'AAAAAAAAAAOAAAAA',46,12.63,0.00,4.67 |
| 'AAAAAAAAAAPBAAAA',66,39.59,969.80,18.60 |
| 'AAAAAAAAAAPCAAAA',90,68.28,0.00,47.79 |
| 'AAAAAAAAABAAAAAA',10.5,71.48,0.00,28.92 |
| 'AAAAAAAAABABAAAA',12.5,100.53,2.23,34.80 |
| 'AAAAAAAAABADAAAA',100,68.67,0.00,50.81 |
| 'AAAAAAAAABAEAAAA',49,15.79,0.00,11.84 |
| 'AAAAAAAAABBCAAAA',52,115.10,0.00,24.17 |
| 'AAAAAAAAABDEAAAA',92,168.96,0.00,23.65 |
| 'AAAAAAAAABEAAAAA',33.33333333333334,58.64,99.47,22.16 |
| 'AAAAAAAAABECAAAA',43,167.74,0.00,88.90 |
| 'AAAAAAAAABEDAAAA',74,129.10,0.00,108.44 |
| 'AAAAAAAAABFBAAAA',36,115.18,0.00,109.42 |
| 'AAAAAAAAABFCAAAA',51,121.98,0.00,17.07 |
| 'AAAAAAAAABFEAAAA',65,117.88,0.00,107.27 |
| 'AAAAAAAAABGBAAAA',52,71.54,0.00,30.28 |
| 'AAAAAAAAABGDAAAA',67.5,58.86,0.00,35.25 |
| 'AAAAAAAAABHAAAAA',71,39.38,804.37,8.38 |
| 'AAAAAAAAABHCAAAA',48,12.67,52.16,4.18 |
| 'AAAAAAAAABHDAAAA',55,17.78,0.00,5.51 |
| 'AAAAAAAAABJAAAAA',32,20.11,0.00,15.68 |
| 'AAAAAAAAABJBAAAA',21,72.33,0.00,11.37 |
| 'AAAAAAAAABJDAAAA',43,74.92,0.00,8.24 |
| 'AAAAAAAAABKAAAAA',67,103.07,0.00,34.01 |
| 'AAAAAAAAABKCAAAA',43,73.93,0.00,48.05 |
| 'AAAAAAAAABKDAAAA',84,102.95,0.00,42.20 |
| 'AAAAAAAAABMAAAAA',58,136.34,0.00,35.44 |
| 'AAAAAAAAABMDAAAA',80,3.06,0.00,1.89 |
| 'AAAAAAAAABNAAAAA',96,81.95,0.00,64.74 |
| 'AAAAAAAAABNCAAAA',42,88.83,0.00,20.65 |
| 'AAAAAAAAABOBAAAA',18,81.49,0.00,58.67 |
| 'AAAAAAAAABOCAAAA',31,73.87,0.00,59.94 |
| 'AAAAAAAAABPBAAAA',48.5,37.83,183.78,11.72 |
| 'AAAAAAAAACACAAAA',60,104.37,351.56,25.31 |
| 'AAAAAAAAACADAAAA',29,43.74,0.00,13.99 |
| 'AAAAAAAAACBBAAAA',44.5,87.51,0.00,36.14 |
| 'AAAAAAAAACBEAAAA',76,156.05,0.00,113.91 |
| 'AAAAAAAAACCDAAAA',26,35.57,0.00,13.01 |
| 'AAAAAAAAACCEAAAA',4,10.98,0.00,4.94 |
| 'AAAAAAAAACDAAAAA',16,87.87,36.26,75.56 |
| 'AAAAAAAAACDCAAAA',27,89.86,0.00,40.43 |
| 'AAAAAAAAACEBAAAA',42,94.58,0.00,51.26 |
| 'AAAAAAAAACFBAAAA',45,88.30,0.00,24.26 |
| 'AAAAAAAAACGAAAAA',47,10.46,0.00,5.64 |
| 'AAAAAAAAACGDAAAA',24,51.54,0.00,18.83 |
| 'AAAAAAAAACHBAAAA',44,103.27,0.00,65.06 |
| 'AAAAAAAAACHCAAAA',68.5,91.68,0.00,66.16 |
| 'AAAAAAAAACIAAAAA',7,25.42,0.00,8.64 |
| 'AAAAAAAAACIBAAAA',21,89.29,915.01,71.43 |
| 'AAAAAAAAACIDAAAA',43,56.28,56.11,4.50 |
| 'AAAAAAAAACLAAAAA',36,125.57,0.00,13.81 |
| 'AAAAAAAAACLDAAAA',61.33333333333334,114.20,0.00,59.12 |
| 'AAAAAAAAACMDAAAA',56,79.02,0.00,64.00 |
| 'AAAAAAAAACNCAAAA',63,54.20,0.00,29.26 |
| 'AAAAAAAAACOAAAAA',50,27.43,229.21,13.43 |
| 'AAAAAAAAACPAAAAA',32,147.62,2480.32,87.09 |
| 'AAAAAAAAACPCAAAA',80,12.60,0.00,0.37 |
| 'AAAAAAAAACPDAAAA',87,105.93,0.00,9.53 |
| 'AAAAAAAAADABAAAA',68.5,35.79,0.00,27.84 |
| 'AAAAAAAAADACAAAA',96,101.54,0.00,99.50 |
| 'AAAAAAAAADAEAAAA',53,74.64,0.00,7.63 |
| 'AAAAAAAAADBBAAAA',6,85.58,234.14,81.30 |
| 'AAAAAAAAADBDAAAA',47,39.33,62.71,12.09 |
| 'AAAAAAAAADBEAAAA',52,2.41,0.00,1.06 |
| 'AAAAAAAAADCAAAAA',91,92.17,0.00,67.28 |
| 'AAAAAAAAADCCAAAA',33,40.80,0.00,28.56 |
| 'AAAAAAAAADDBAAAA',45,18.63,0.00,17.69 |
| 'AAAAAAAAADDCAAAA',66,162.17,1525.90,37.29 |
| 'AAAAAAAAADDEAAAA',35,78.25,0.00,36.63 |
| 'AAAAAAAAADEBAAAA',59.5,110.38,157.96,16.16 |
| 'AAAAAAAAADEEAAAA',17,54.54,0.00,16.36 |
| 'AAAAAAAAADFAAAAA',44,133.51,0.00,25.36 |
| 'AAAAAAAAADGBAAAA',31,107.55,919.82,56.53 |
| 'AAAAAAAAADGCAAAA',78,119.61,0.00,74.15 |
| 'AAAAAAAAADGEAAAA',45.5,99.30,0.00,1.06 |
| 'AAAAAAAAADHAAAAA',86,81.09,0.00,37.30 |
| 'AAAAAAAAADHBAAAA',28,68.58,223.79,53.61 |
| ---- TYPES |
| STRING, DOUBLE, DECIMAL, DECIMAL, DECIMAL |
| ==== |